Category Archives: SQL Server 2012

SQL Server Diagnostic Information Queries for November 2013

I have made a number updates and bug fixes, including some additional columns in some of the queries for all of the versions of my SQL Server Diagnostic Information Queries for this month.  I have also added more comments and … 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

SQL Server Diagnostic Information Queries for October 2013

I have made some minor updates and bug fixes for all of my SQL Server Diagnostic Information Queries for this month.  Rather than having a separate blog post for each version, I’ll just put the links for all five versions … Continue reading

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

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

Selecting an Appropriate Intel Xeon E5-2600 v2 Family Processor for SQL Server 2012

Intel has finally released the 22nm Xeon E5-2600 v2 Family (Ivy Bridge-EP) of processors that will be used in two-socket servers. These processors have slightly better single-threaded performance than the previous 32nm Xeon E5-2600 Family (Sandy Bridge-EP) processors, along with … Continue reading

Posted in Computer Hardware, Intel, Ivy Bridge-EP, SQL Server 2012 | Tagged | 3 Comments

TPC-E Benchmark Results for Intel Xeon E5-2697 v2

Two new TPC-E benchmark results have shown up for two-socket database servers using the brand new, 22nm Intel Xeon E5-2697 v2 (Ivy Bridge-EP) processor. The first result is for an IBM System x3650 M4 with 512GB of RAM, that has … Continue reading

Posted in SQL Server 2012, TPC-E | Tagged | Leave a 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 2012 RTM CU9

On August 20, Microsoft released SQL Server 2012 RTM Cumulative Update 9, which is Build 11.0.2419. I count seven fixes in the public fix list. This a very low number of hotfixes compared to all previous SQL Server 2012 Cumulative … Continue reading

Posted in Cumulative Update, SQL Server 2012 | Tagged | 1 Comment