Category Archives: SQL Server 2008

SQL Server Diagnostic Information Queries for September 2013

I have gone through and made some minor updates and bug fixes for all of my SQL Server Diagnostic Information Queries for this month. I have also added a new version for SQL Server 2014. Rather than having a separate … Continue reading

Posted in Diagnostic Queries, SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012, SQL Server 2014 | Tagged , | 1 Comment

Fixing a Bug: DBCC CHECKDB data purity checks are skipped for master and model

Fellow MVP Paul Randal just blogged about an issue he has discovered with how the master and model databases are created in SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, and SQL Server 2012. I just checked, and … Continue reading

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

SQL Server Diagnostic Information Queries for August 2013

I have gone through and made some minor updates and bug fixes for all of my SQL Server Diagnostic Information Queries for this month. I also added two new queries at the end of the script, to collect some information … Continue reading

Posted in Diagnostic Queries, SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012 | Tagged , | 15 Comments

SQL Server 2008 Service Pack 3 CU12

On July 15, Microsoft released SQL Server 2008 Service Pack 3 Cumulative Update 12, which is Build 10.0.5844. I count six fixes in the public fix list. If you are still running SQL Server 2008 (and I know many people … Continue reading

Posted in SQL Server 2008 | Tagged | 1 Comment

SQL Server 2008 Diagnostic Information Queries (May 2013)

Here is the May 2013 version of my SQL Server 2008 Diagnostic Information Queries, with some minor tweaks and improvements to several of the existing queries. I have decided to split off this into a separate version just for SQL … Continue reading

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

SQL Server 2008 Service Pack 3 Cumulative Update 9

Microsoft has released SQL Server 2008 Service Pack 3 Cumulative Update 9, which is build 10.00.5829. As you might expect from the build number (which is only one number higher than SQL Server 2008 Service Pack 3 Cumulative Update 8), … Continue reading

Posted in SQL Server 2008 | Tagged | Leave a comment

SQL Server 2008 Diagnostic Information Queries (Jan 2013)

Here is the January 2013 version of my SQL Server 2008 Diagnostic Information Queries, with some minor tweaks and improvements to several of the existing queries mainly focusing on collecting some information about whether Change Data Capture (CDC) is enabled. … Continue reading

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

SQL Server 2008 Diagnostic Information Queries (Dec 2012)

Here is the December 2012 version of my SQL Server 2008 Diagnostic Information Queries, with some minor tweaks and improvements to a couple of the existing queries. There is also one new query at the very end, adapted from Erin … Continue reading

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

SQL Server 2008 Diagnostic Information Queries (Nov 2012)

Here is the November 2012 version of my SQL Server 2008 Diagnostic Information Queries, with some minor tweaks and improvements to a couple of the existing queries. To go with it is an updated, blank 2008 results spreadsheet, where the … Continue reading

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

SQL Server 2008 Diagnostic Information Queries (Oct 2012)

Here is the October 2012 version of my SQL Server 2008 Diagnostic Information Queries, with some minor tweaks and improvements to a number of the existing queries, and one new query. To go with it is an updated, blank 2008 … Continue reading

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