Category Archives: SQL Server 2008 R2

2012 Blog Statistics in Review

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)

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

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

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)

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

DMV Emergency Room!

I had the opportunity to present DMV Emergency Room! at SQLSaturday #169 in Denver, Colorado on September 22, 2012. I had a nice, full room with about 40-50 people, which is pretty good for a local event. I want to … Continue reading

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

SQL Server 2008 Diagnostic Information Queries (August 2012)

Here is the August 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 , | 8 Comments

SQL Server 2008 R2 Service Pack 2 Cumulative Update 1

Microsoft has released SQL Server 2008 R2 Service Pack 2 Cumulative Update 1, which is Build 10.50.4260.0. This CU has 35 fixes listed in the public fix list. This CU should get the SQL Server 2008 R2 SP2 branch aligned … Continue reading

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

SQL Server 2008 R2 Service Pack 2

Microsoft has released SQL Server 2008 R2 Service Pack 2, which is Build 10.50.4000. It includes the fixes up through SQL Server 2008 Service Pack 1 CU5. If you have already installed SQL Server 2008 R2 SP1 CU6 or CU7, … Continue reading

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