Managing Data Compression in SQL Server 2008

Data Compression in SQL Server 2008: The size of the databases are increased drastically due to –          Movement of data from flat files into the databases due to east of management, accessibility, analysis and reporting. –          Significant amount of data stored in databases is born digitally. Hence the hardware needed to maintain the databases size…

2

Grouping Sets in SQL Server 2008

Introduction: This post describes a new feature in SQL Server 2008 – Grouping Sets The result set returned by GROUPING SET is the union of the aggregates based on the columns specified in each set in the Grouping set. Whenever an aggregate function is required, GROUPBY clause is the only solution. There can be a…

3

SQL Change Tracking in SQL Server 2008

What is Change Tracking? Change tracking is a new feature in SQL Server 2008 that allows applications to query for information about the changes that have been made to user tables since a previous point in time.  Change tracking is intended to be used as a building-block used by synchronization components or applications.   In…

6