This session will show you how the query optimizer has been updated to work with the new SQL Server 2014 features and to provide better performance to existing ones. It starts by explaining how the query optimizer is used in Hekaton by both natively compiled stored procedures and by traditional stored procedures accessing memory-optimized tables through the query interop functionality. The session will then move to cardinality estimation. SQL Server 2014 includes a new cardinality estimator and, since every query has to work with either the new or the old cardinality estimator, it is essential to understand how they work, what their differences are and how to detect and troubleshoot plan regressions and other related problems. The session concludes explaining incremental statistics. Incremental statistics is a new feature that you can use to update statistics at the partition level which can be an enormous help in updating statistics in large tables.
Presented by Benjamin Nevarez at SQLBits XIV