SQL Server 2014 introduced a new cardinality estimator. 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.

You will learn:

The differences between legacy and newer cardinality estimators
How to know if cardinality estimation is causing performance issues
How to revert back to the legacy version if needed