Microsoft has released Cumulative Update #2 for SQL Server 2014. Important! This Cumulative Update fixes the data loss / corruption issue with online index rebuilds that I talked about in this blog post on...
Monthly Archive: June 2014
Following a recent update, I take a first look at a new performance enhancement and trace flag (2453) aimed at improving cardinality estimates for table variables and table-valued parameters.
I look at some unexpected behavior with the CASE expression and some of its derivatives.
Service Pack 2 is available: http://www.microsoft.com/en-us/download/details.aspx?id=43340 The build number is 11.0.5058, and this includes fixes up to and including SQL Server 2012 SP1 CU #9. (The complete list of fixes is exhaustive, including all...
Tip : Connect to SQL Servers in another domain using Windows Authentication
I warn about a parallelism bug in SQL Server 2012 and 2014 that could lead to data loss following online index rebuilds.
Tip : Choosing Between SQL Server 2012 and SQL Server 2014