The way SQL Server estimates cardinality for a query has been updated for SQL 2014. In this session we will discuss why cardinality matters, the differences between the SQL 2014 cardinality and previous versions, and how to evaluate if your queries will benefit after upgrading to SQL 2014.
Presented by Thomas LaRock at SQLBits XII
Slide Deck 6.8 MB