Category Archives: SQL Server 2008 R2

SQL Server 2008 R2 Diagnostic Information Queries (May 2013)

Posted on May 6, 2013 by

Here is the May 2013 version of my SQL Server 2008 R2 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 … Continue reading →

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

New SQL Server Cumulative Updates

Posted on April 15, 2013 by

Microsoft has released three new Cumulative Updates for SQL Server today, two for SQL Server 2008 R2 and one for SQL Server 2012. The first one is SQL Server 2008 R2 SP1 CU12, which is Build 10.50.2874. This CU has … Continue reading →

Posted in SQL Server 2008 R2, SQL Server 2012 | Tagged | 4 Comments

SQL Server 2008 R2 Diagnostic Information Queries (Feb 2013)

Posted on February 5, 2013 by

Here is the February 2013 version of my SQL Server 2008 R2 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 … Continue reading →

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

SQL Server 2008 Diagnostic Information Queries (Jan 2013)

Posted on January 12, 2013 by

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

2012 Blog Statistics in Review

Posted on December 30, 2012 by

The WordPress.com stats helper monkeys prepared a 2012 annual report for this blog. Here’s an excerpt: About 55,000 tourists visit Liechtenstein every year. This blog was viewed about 400,000 times in 2012. If it were Liechtenstein, it would take about … Continue reading →

Posted in SQL Server 2008 R2 | Leave a comment

SQL Server 2008 Diagnostic Information Queries (Dec 2012)

Posted on December 18, 2012 by

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 R2 SP2 Cumulative Update 4

Posted on December 17, 2012 by

Microsoft has released SQL Server 2008 R2 Service Pack 2 Cumulative Update 4, which is Build 10.50.4270. I count 34 fixes in the public fix list. Some of these fixes look fairly important, so you should take a look at … Continue reading →

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

SQL Server 2008 R2 SP1 Cumulative Update 10

Posted on December 17, 2012 by

Microsoft has released SQL Server 2008 R2 Service Pack 1 Cumulative Update 10, which is Build 10.50.2868. I count 15 fixes in the public fix list. Some of these fixes look fairly important, so you should take a look at … Continue reading →

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

SQL Server 2008 Diagnostic Information Queries (Nov 2012)

Posted on November 27, 2012 by

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)

Posted on October 19, 2012 by

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