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
Links
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