Session

Cardinality Estimates in Microsoft SQL Server

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

Thomas LaRock

Technical Advocate

Springfield, Massachusetts, United States

Actions

Please note that Sessionize is not responsible for the accuracy or validity of the data provided by speakers. If you suspect this profile to be fake or spam, please let us know.

Jump to top