Nice things inside SQL Server, System Center Configuration Manager

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...

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...

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...