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.