Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Archives: December 2012

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 7 years for that many people to see it. Your…

Read more

0 comments, 575 reads

Posted in Glenn Berry's SQL Server Performance on 31 December 2012

SQL Server 2012 Standard Edition Licensing Limits

As you might be aware, SQL Server 2012 Standard Edition has some hardware-related licensing limits that I think should be adjusted in light of the capabilities of modern, commodity server hardware.

As a DBA and consultant, I would like to see everyone running SQL Server 2012 Enterprise Edition. It has… Read more

10 comments, 3,726 reads

Posted in Glenn Berry's SQL Server Performance on 29 December 2012

SQL Server 2012 Diagnostic Information Queries (Dec 2012)

Here is the December 2012 version of my SQL Server 2012 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 my colleague, Erin Stellato.

To go with it is…

Read more

0 comments, 566 reads

Posted in Glenn Berry's SQL Server Performance on 28 December 2012

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 Stellato.

To go with it is an updated, blank…

Read more

3 comments, 695 reads

Posted in Glenn Berry's SQL Server Performance on 18 December 2012

SQL Server 2012 Cumulative Update 5

Microsoft has released SQL Server 2012 Cumulative Update 5, which is Build 11.0.2395. I count 28 fixes in the public fix list. Some of these fixes look fairly important, so you should take a look at the fix list.

Here are a couple of the more important hotfixes:

SQL…

Read more

0 comments, 925 reads

Posted in Glenn Berry's SQL Server Performance on 18 December 2012

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 the fix list.

This Cumulative Update is only for SQL…

Read more

1 comments, 1,781 reads

Posted in Glenn Berry's SQL Server Performance on 18 December 2012

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 the fix list.

This Cumulative Update is only for… Read more

0 comments, 964 reads

Posted in Glenn Berry's SQL Server Performance on 17 December 2012

Two Blogs, One Writer

I started blogging back on August 9, 2006, so I have been at it for quite a while. I am pretty proud that I have stayed pretty active with relatively frequent posts over the past six-plus years. I don’t plan on changing that anytime soon. I will occasionally write about… Read more

0 comments, 667 reads

Posted in Glenn Berry's SQL Server Performance on 7 December 2012

SQL Server 2005 Diagnostic Information Queries (Dec 2012)

Here is the December 2012 version of my SQL Server 2005 Diagnostic Information Queries, with some minor tweaks and improvements. I dropped a couple of redundant queries, and added a new query at the end.

To go with it is an updated, blank results spreadsheet, where the tabs…

Read more

4 comments, 797 reads

Posted in Glenn Berry's SQL Server Performance on 7 December 2012

OT: Space Exploration and the Future of Humanity

I am old enough to remember watching the Apollo 11 landing in 1969 as a young child. Before and after that, I can remember drawing pictures of Saturn V rockets blasting off, with smoke billowing on either side. It is hard to describe how much so many people were inspired… Read more

1 comments, 896 reads

Posted in Glenn Berry's SQL Server Performance on 3 December 2012