Removing the SQL Server Management Data Warehouse
Tip : Removing the SQL Server Management Data Warehouse
Monthly Archive: July 2012
SQL Server 2008 R2 Service Pack 2 is available
Today Microsoft has released Service Pack 2 for SQL Server 2008 R2. http://www.microsoft.com/en-us/download/details.aspx?id=30437 The build number is 10.50.4000.0 and it includes fixes from 2008 R2 SP1 Cumulative Updates 1, 2, 3, 4 and 5....
Split strings the right way – or the next best way
I explore some common approaches people use to split strings, complete with performance analysis.
SQL Sentry is sponsoring a new blog : SQLPerformance.com
This week, SQL Sentry has launched a new performance-related SQL Server blog: SQLPerformance.com. I'm very excited about this new project, and I'm looking forward to some good information flow in both directions. The goal...
SQL Server 2012 Service Pack 1 CTP3 is available – but there's a catch
Back on July 5th, I somehow missed that the SQL Server team had published a Community Technology Preview (CTP) for SQL Server 2012 Service Pack 1. This is the 3rd CTP (I guess I...
Best approaches for running totals – updated for SQL Server 2012
See some of the ways to produce running totals, including new functionality in SQL Server 2012.
SQL Server Queries With Hints
Tip : SQL Server Queries With Hints
July 2012 : Cumulative Updates for SQL Server 2008 are available
Today Microsoft has released two new cumulative updates for SQL Server 2008. Cumulative Update #11 for SQL Server 2008 Service Pack 2 Knowledge Base Article: KB #2715951 At the time of writing, there are...
A new era begins : Welcome, Kevin Kline, to SQL Sentry!
It is with great pleasure that I welcome Kevin Kline to his new role as Director of Engineering Services at SQL Sentry. In Internet terms, Kevin and I go "way back." We've been at...
Connect Digest : 2012-07-06
I've filed a few Connect items recently that I think are important. In #752210, I complain that the documentation for DDL triggers suggests that they can prevent certain DDL from being run, which is...