Dave Ballantyne
clearskysql.co.uk
Dave is a freelance SQL Server database architect / designer / developer / consultant and lives near London, England. He is a regular speaker at UK and European events and user groups.
SQLBits 2015
SQL2014 : The all new cardinality estimator
In SQL Server 2014, there have been many changes aimed at giving a more accurate number of rows, and therefore better plans. This session will be a look at these changes, comparing and contrasting with SQL2012/2008 to see how they help.
A vital component inside the query optimizer is the cardinalityestimator, these algorithms calculate the estimated numberof rows that will be outputted from each operator. In SQL Server 2014, therehave been many changes aimed at giving a more accurate number of rows, andtherefore better plans.This session will be a look at these changes, comparing andcontrasting with SQL2012/2008 to see how they help.