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.
June 2014
I look at some unexpected behavior with the CASE expression and some of its derivatives.
Tip : Connect to SQL Servers in another domain using Windows Authentication
Tip : Choosing Between SQL Server 2012 and SQL Server 2014