Category Archives: SQL Server 2005

Gradually Deleting Data in SQL Server

Posted on August 13, 2011 by

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

SQL Server 2005 SP4 Cumulative Update 3

Posted on March 22, 2011 by

Microsoft has released SQL Server 2005 SP4 Cumulative Update 3, which is Build 9.0.5266. There are only five fixes listed in the KB article for this final release. Here is what Microsoft says about the release: SQL Server 2005 SP4 … Continue reading →

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

SQL Server 2005 SP3 Cumulative Update #15

Posted on March 22, 2011 by

Microsoft has released SQL Server 2005 SP3 Cumulative Update 15, which is Build 9.0.4325. There are only six fixes included in this final release. Here is what Microsoft says about the release: SQL Server 2005 SP3 CU 15 marks the … Continue reading →

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

Mirrored Database Backups vs. Striped Database Backups

Posted on March 13, 2011 by

I have seen a few people get confused about the difference between a mirrored database backup (which is only available in SQL Server 2005 Enterprise Edition and above) and a striped database backup. A Mirrored Backup is simply a database … Continue reading →

Posted in SQL Server 2005, SQL Server 2008, SQL Server 2008 R2 | Tagged | 3 Comments

March 2011 Version of SQL Server 2005 and 2008 Diagnostic Queries

Posted on March 7, 2011 by

Another month, and another new version of my SQL Server Diagnostic Information queries for both SQL Server 2005 and SQL Server 2008/2008 R2. I have uploaded the scripts for each version to DropBox (see the links below). There are two … Continue reading →

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

New SQL Server 2005 Cumulative Updates

Posted on February 22, 2011 by

Microsoft has released two new Cumulative Updates for SQL Server 2005. The first one is SQL Server 2005 SP3 CU14, which is Build 9.00.4317. The second one is SQL Server 2005 SP4 CU2, which is Build 9.00.5259. There are only … Continue reading →

Posted in SQL Server 2005 | Tagged | 2 Comments

How to Interpret SELECT @@VERSION in SQL Server

Posted on February 17, 2011 by

One common point of confusion that I often see when people run the SELECT @@VERSION query is how to properly understand the results that are returned. I have seen many people mix up the SQL Server portion of the results … Continue reading →

Posted in SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, Windows Server 2008 R2 | Tagged | 3 Comments

SQL Server and the “Lock pages in memory” Right in Windows Server

Posted on February 14, 2011 by

Another Windows setting you might want to enable is “Lock pages in memory”. There is some controversy within the SQL Server community and within Microsoft about whether and when you should enable this setting. Before you decide whether you want … Continue reading →

Posted in SQL Server 2005, SQL Server 2008, SQL Server 2008 R2 | Tagged | 57 Comments

Windows Instant File Initialization and SQL Server

Posted on February 10, 2011 by

One Windows setting that I think is extremely important for SQL Server usage is the “Perform volume maintenance tasks” right, which enables Windows Instant File Initialization. On a Windows Server 2003 or newer operating system, using SQL Server 2005 or … Continue reading →

Posted in SQL Server 2005, SQL Server 2008, SQL Server 2008 R2 | Tagged | 16 Comments

February 2011 Version of SQL Server 2005 and 2008 Diagnostic Information Queries

Posted on February 2, 2011 by

Wow, it is already February 2011, so here are the February 2011 versions of the SQL Server 2005 Diagnostic Information Queries and the SQL Server 2008 Diagnostic Information Queries. To go with them are the matching blank results spreadsheets for … Continue reading →

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