Category Archives: SQL Server 2005

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

Posted on February 2, 2011 by Glenn Berry

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

Microsoft Support Policies for Windows Server and SQL Server

Posted on January 30, 2011 by Glenn Berry

Microsoft provides ten years of support (five years Mainstream Support and five years Extended Support) at the supported service pack level for Business and Developer products, which include Windows Server and SQL Server. The term “supported service pack level” means … Continue reading →

Posted in Computer Hardware, SQL Server 2005, Windows Server 2008, Windows Server 2008 R2 | Tagged , | 4 Comments

How to Obtain and Install SQL Server Service Packs and Cumulative Updates

Posted on January 12, 2011 by Glenn Berry

If you are in charge of one or more SQL Server instances, whether they are on a laptop, or a large Production data center, you need to be aware of how SQL Server updates and fixes are released, and how … Continue reading →

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

Fun with Extended Properties in SQL Server 2008

Posted on January 10, 2011 by Glenn Berry

Most technical professionals don’t seem to enjoy writing and maintaining documentation for their databases. I know that documentation falls pretty low on my favorites list. One pretty easy way to include some “built-in” database documentation for your databases (which could … Continue reading →

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

SQL Server Index Tuning for Mere Mortals

Posted on January 6, 2011 by Glenn Berry

One of the most important things to measure, monitor, and “get right” for good overall SQL Server OLTP performance is the number and composition of your SQL Server relational indexes. It is extremely important to have neither too many or … Continue reading →

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

Updated SQL 2005 and 2008 Diagnostic Queries

Posted on December 29, 2010 by Glenn Berry

Since it is almost January 2011, I thought I would post the January 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 … Continue reading →

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

A Collection of Good Information About Controlling VLFs in SQL Server

Posted on December 27, 2010 by Glenn Berry

Because of the default settings in SQL Server (for the model database), and a lack of understanding about how the transaction log should be sized and maintained, I run into many databases that have a high number of virtual log … Continue reading →

Posted in SQL Server 2005, SQL Server 2008, SQL Server 2008 R2 | Tagged , | 1 Comment

SQL Server 2005 SP3 Cumulative Update 13 Released

Posted on December 22, 2010 by Glenn Berry

Microsoft has released SQL Server 2005 SP3 Cumulative Update 13, which is Build 4315. It was actually released on Monday, but the “View and request hotfix downloads” link was broken until earlier today.  I waited to blog about it until … Continue reading →

Posted in SQL Server 2005 | Tagged | 3 Comments

SQL Server 2005 Service Pack 4 RTM Released

Posted on December 20, 2010 by Glenn Berry

Last Friday afternoon (December 17, 2010), Microsoft released the final RTM build of Service Pack 4 (SP4) for SQL Server 2005. This is scheduled to be the last Service Pack for SQL Server 2005, which is not that surprising, since … Continue reading →

Posted in SQL Server 2005 | Tagged | 1 Comment

SQL Server Hardware Book

Posted on December 14, 2010 by Glenn Berry

One reason (besides laziness) that I have been fairly light on my blogging lately is that I have been working to finish my first solo book, SQL Server Hardware, which is due to be published in February 2011 by Simple … Continue reading →

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