Cardinality Estimates in Microsoft SQL Server

2016

TL; DR

Attend this session and understand how, why, and when SQL Server uses statistics and how the new CE will help improve performance.

Session Details

The way SQL Server estimates cardinality for a query has been updated in 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 from previous versions of SQL Server.

3 things you'll get out of this session

Speaker

Thomas LaRock's previous sessions

Database Design Throwdown - 2017

Cardinality Estimates in Microsoft SQL Server - 2016

From Here to Azure - 2015

Database Design: Size DOES Matter - 2015

Cardinality Estimates in Microsoft SQL Server 2014 - 2014

Monitoring Databases in a Virtual Environment - 2014

Database Design: Size Does Matter! - 2013