SQL Server 2012 Service Pack 1 Cumulative Update #11 is available!

The SQL Server team has released SQL Server 2012 SP1 Cumulative Update #11. This cumulative update includes a fix for the online index rebuild corruption issue I discussed recently on SQLPerformance.com. KB Article: KB #2975396 Build # is 11.0.3449 Currently there are 32 public fixes listed (32 total)  Relevant for […]

T-SQL Tuesday #56 : Assumptions

This month's T-SQL Tuesday is about assumptions in SQL Server. Over on our new consolidated team blog at SQL Sentry, I discuss the following assumptions I come across with relative frequency: Case will always short circuit A seek is better than a scan, always A query without ORDER BY will […]

June 2014 Cumulative Update for SQL Server 2008 R2 SP2

Microsoft has released the final Cumulative Update (#13) for SQL Server 2008 R2 Service Pack 2. KB Article: KB #2967540 15 public fixes listed at time of publication (17 fixes total) Build number is 10.50.4319 Relevant for @@VERSION 10.50.4000 through 10.50.4318 My usual disclaimer: these updates are NOT for SQL […]