Category Archives: SQL Server Denali

SQL Server 2012 RTM Cumulative Update 4

Posted on October 16, 2012 by Glenn Berry

Microsoft has released SQL Server 2012 RTM Cumulative Update 4, which is build 11.00.2383.0. By my count, there are 25 fixes in the public fix list for this cumulative update. The first four cumulative updates for SQL Server 2012 have … Continue reading →

Posted in Microsoft, SQL Server 2012, SQL Server Denali | Tagged , | 3 Comments

SQL Server 2012 Diagnostic Information Queries (October 2012)

Posted on October 1, 2012 by Glenn Berry

Here is the October 2012 version of my SQL Server 2012 Diagnostic Information Queries, with some minor tweaks and improvements to a number of the existing queries.  I also removed three of the existing queries, since they seemed a little … Continue reading →

Posted in SQL Server 2012, SQL Server Denali | Tagged , | 3 Comments

SQL Server 2012 Diagnostic Information Queries (June 2012)

Posted on June 11, 2012 by Glenn Berry

Here is the latest version of my SQL Server 2012 Diagnostic Information Queries, with some minor tweaks and improvements, including query numbering and one new query at the end. To go with it is an updated, blank results spreadsheet, where … Continue reading →

Posted in SQL Server 2012, SQL Server Denali | Tagged , | 5 Comments

The Fantastic 12 of SQL Server 2012

Posted on May 7, 2012 by Glenn Berry

The SQL Server Team Blog is in the midst of posting twelve, short weekly videos that let someone from the SQL Server Product team talk about their favorite features and improvements in SQL Server 2012. These videos go up every … Continue reading →

Posted in Microsoft, SQL Server, SQL Server 2012, SQL Server Denali | Tagged | 1 Comment

SQL Server 2012 Diagnostic Information Queries (April 2012)

Posted on April 26, 2012 by Glenn Berry

It is hard to believe, but SQL Server 2012 has been GA for nearly a month now. Because of this, I thought it was a good time to release an updated version of my SQL Server 2012 Diagnostic Information Queries. … Continue reading →

Posted in SQL Server 2012, SQL Server Denali | Tagged , | 1 Comment

SQL Server 2012 Diagnostic Information Queries (December 2011)

Posted on December 19, 2011 by Glenn Berry

Since the final RTM release of SQL Server is getting ever closer, I thought it was a good time to release an updated version of my SQL Server 2012 Diagnostic Information Queries. These queries are meant to be used with … Continue reading →

Posted in SQL Server 2012, SQL Server Denali | Tagged , | 3 Comments

Tuesday Hardware Tidbits, Nov 29, 2011

Posted on November 29, 2011 by Glenn Berry

Since Microsoft is moving to core-based licensing for SQL Server 2012 Enterprise Edition, with a minimum of four physical core licenses per physical socket, I have had a few questions about what is the “best” quad-core processor to choose for … Continue reading →

Posted in Computer Hardware, Processors, SQL Server 2012, SQL Server Denali | Tagged , | 1 Comment

October 2011 SQL Server 2012 Diagnostic Information Queries

Posted on October 19, 2011 by Glenn Berry

Since Microsoft released the official name for “SQL Server Code Named Denali” last week at the PASS 2011 Summit, it seems like a good time for me to release an updated version of my SQL Server 2012 Diagnostic Information Queries.  … Continue reading →

Posted in Microsoft, SQL Server 2012, SQL Server Denali | Tagged | Leave a comment

SQL Server MVP Deep Dives, Volume 2 Available at PASS 2011 Summit

Posted on September 24, 2011 by Glenn Berry

Volume 2 of the SQL Server MVP Deep Dives book is now available for pre-order from Amazon and from Manning. This book has all new content, rather than just an update or refresh of Volume 1. Just like the first … Continue reading →

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

Gradually Deleting Data in SQL Server

Posted on August 13, 2011 by Glenn Berry

If you have a situation where you have a very large table in SQL Server, where you need to periodically delete tens of millions of rows of data, there are several ways to do it. If you have a maintenance … Continue reading →

Posted in SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server Denali | 23 Comments