Investigating SQL Server 2008 Wait Events with XEVENTS

Some reasons for the slow-running of database applications aren't obvious. Occasionally, even the profiler won't tell you enough to remedy a problem, especially when a SQL Statement is being forced to wait. Now, in SQL Server 2008, come XEvents, which allow you to look at those waits that are slowing your SQL Statements. Mario Broodbakker continues his series about SQL Server Wait Events

SQL Server 2008 RTM

SQL Server 2008 has RTM'd and is available on MSDN.

GROUP BY ALL

Using Column Sets with Sparse Columns

This article provides an overview of the use of Column Sets with Spare Columns in SQL Server 2008

Page Compression

How to configure and Use Database Backup Compression in SQL Server 2008

SQL Server 2008 introduces the Database Backup Compression feature. This article describes how to take advantage of this new feature

Sparse Columns

Data Compression

Resource Governor

Coming In August

SQL Server 2008 is coming in August, with the same pricing as SQL Server 2005.