Following the recent release of SQL Server 2012 Service Pack 2 and SQL Server 2014 Cumulative Update #3, SQL Sentry's Aaron Bertrand (@AaronBertrand) takes a first look at a new performance enhancement and trace flag (2453) aimed at improving cardinality estimates for table variables and table-valued parameters.
Paul White (@SQL_Kiwi) looks into a limitation of filtered indexes and demonstrates some dangers involving performance degradation and the risk of deadlocks.
Paul White (@SQL_Kiwi) dives deep into new execution plan information introduced in SQL Server 2012; specifically, thread reservation and usage information for parallel plans.
Aaron Bertrand (@AaronBertrand) investigates a case where two different methods of deriving an inline constant can lead to very different cardinality estimates.
