Removing the SQL Server Management Data Warehouse
Tip : Removing the SQL Server Management Data Warehouse
Tip : Removing the SQL Server Management Data Warehouse
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....
I explore some common approaches people use to split strings, complete with performance analysis.
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...
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...
See some of the ways to produce running totals, including new functionality in SQL Server 2012.
Tip : SQL Server Queries With Hints
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...
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...
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...