SQH14 Cardinality Estimates in SQL Server 2014

11/20/2014

3:00pm - 4:15pm

Level: Intermediate to Advanced

Thomas LaRock

Head Geek

SolarWinds

In this session, Thomas will review everything you'll need to know about Cardinality Estimates in SQL Server 2014.

The way SQL Server estimates cardinality for a query has been updated for 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 to SQL 2014.

You will learn:
  • Differences between old and new cardinality estimator
  • How to know which one is being used
  • How to know if the new version is causing performance issues
  • How to revert back to the old version if needed