Techorama 2017

SQL Server 2014 introduced a new cardinality estimator (CE). This feature allows for statistics to be calculated differently than previous versions of SQL Server, often (but not always) resulting in better query performance.

Attend this session and understand how, why, and when SQL Server uses statistics and how this new feature will help improve performance. We will discuss the differences between the legacy and new CE, discuss examples, see the CE in action, and discuss tips and tricks for you to deploy in order to make certain your queries are getting the best execution plans.