SQL Sentry's Aaron Bertrand (@">

Aaron Bertrand : New Trace Flag to Fix Table Variable Performance

Following the recent release of SQL Server 2012 Service Pack 2, SQL Sentry's Aaron Bertrand (@AaronBertrand) takes a first look at a new performance enhancement and trace flag aimed at improving cardinality estimates for table variables and table-valued parameters.

SQLPerformance.com is about providing innovative and practical solutions for improving SQL Server performance. Whether you are running a 3rd party application database where very little can be changed, or you are a DBA at a site where getting the application developers to change anything is next to impossible, industry experts including Paul Randal, Jonathan Kehayias, Erin Stellato and Paul White will cover both the "how" and the "why."