Cardinality Estimates in Microsoft 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.
Thomas LaRock is a Microsoft Certified Master, a SQL Server MVP, a VMWare vExpert, and a Microsoft Certified Trainer with over 15 years experience in the IT industry in various roles such as programmer, developer, analyst, and database administrator. He is also the author of "DBA Survivor: Become a Rock Star DBA" and has participated in the technical review of several other books. Currently, Thomas is a Technical Evangelist for Confio Software.