Category Archives: SQL Server 2008

A Couple of Data Compression Tricks in SQL Server 2008

Posted on August 23, 2011 by Glenn Berry

As I have said several times before, I am a big fan of data compression in SQL Server 2008 and above. Data compression is an Enterprise Edition only feature that was added to SQL Server 2008, and enhanced with Unicode … Continue reading →

Posted in SQL Server 2008, SQL Server 2008 R2 | Tagged | 8 Comments

Gradually Deleting Data in SQL Server

Posted on August 13, 2011 by Glenn Berry

If you have a situation where you have a very large table in SQL Server, where you need to periodically delete tens of millions of rows of data, there are several ways to do it. If you have a maintenance … Continue reading →

Posted in SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server Denali | 23 Comments

August 2011 SQL Server 2008 Instance Level Diagnostic Queries

Posted on August 1, 2011 by Glenn Berry

Since it is August 1, 2011 (which is also my birthday), I thought it would be a good time to unveil a completely new set of Diagnostic queries that focus completely on SQL Server instance level metrics. My previous DMV … Continue reading →

Posted in SQL Server 2008, SQL Server 2008 R2 | Tagged | 11 Comments

Building or Buying a High Performance, Low Cost Desktop Machine for SQL Server Development and Testing

Posted on July 23, 2011 by Glenn Berry

There was a lengthy discussion on Twitter this morning, where one of my friends, Grant Fritchey (Twitter) was asking the community for suggestions about a good hardware setup that would enable him to run two to three concurrent virtual machines, … Continue reading →

Posted in Computer Hardware, Processors, SQL Server 2008, SQL Server 2008 R2, SQL Server Denali | Tagged | 15 Comments

Microsoft SQL Server 2008 SP2 Cumulative Update 5 Released

Posted on July 18, 2011 by Glenn Berry

Microsoft has released Cumulative Update 5 for SQL Server 2008 Service Pack 2. This CU has ten fixes listed in the knowledge base article, and it is Build 10.0.4316. This Cumulative Update is only for SQL Server 2008 SP2 (not … Continue reading →

Posted in Microsoft, SQL Server 2008 | Tagged | Leave a comment

July 2011 Version of SQL Server 2008 Diagnostic Queries

Posted on June 30, 2011 by Glenn Berry

Since July is only one day away, its time for the updated version of my SQL Server 2008 Diagnostic Information Queries. There is also an updated version of the results spreadsheet, with an additional tab for the latest new query … Continue reading →

Posted in Computer Hardware, SQL Server 2008, SQL Server 2008 R2 | Tagged | 11 Comments

Presenting Two Sessions at PASS Summit 2011

Posted on June 19, 2011 by Glenn Berry

I found out earlier this week that I was fortunate enough to have my half day session on “Scaling SQL Server” accepted for the PASS Summit 2011, which was quite a pleasant surprise! I had previously been informed that I … Continue reading →

Posted in Computer Hardware, PASS, SQL Server 2008, SQL Server 2008 R2, SQL Server Denali, Teaching | Tagged | 1 Comment

June 2011 Version of SQL Server 2008 Diagnostic Queries

Posted on June 2, 2011 by Glenn Berry

Since it is June, I thought it was time to update my SQL Server 2008 (and 2008 R2) Diagnostic Information Queries. This month has one new query, which rolls up total CPU usage by database for the current SQL Server … Continue reading →

Posted in SQL Server 2008, SQL Server 2008 R2 | Tagged | 7 Comments

SQL Server 2008 SP1 CU14 and SQL Server 2008 SP2 CU4 Released

Posted on May 17, 2011 by Glenn Berry

Microsoft has released two new Cumulative Updates for SQL Server 2008 SP1 and SQL Server 2008 SP2. The first one is SQL Server 2008 SP1 Cumulative Update 14, which is Build 2821. This CU has only ten fixes. The second … Continue reading →

Posted in Microsoft, SQL Server 2008 | Tagged | 1 Comment

May 2011 SQL Server 2008 Diagnostic Information Queries

Posted on May 16, 2011 by Glenn Berry

Since we are in the middle of May 2011, I thought was was time to update my SQL Server 2008 Diagnostic Information Queries. These are very similar to the April 2011 version except for one new query at the end … Continue reading →

Posted in SQL Server 2008, SQL Server 2008 R2 | Tagged | 5 Comments