SQLBits 2014

Cardinality Estimates in Microsoft SQL Server 2014

Attend this session and understand how, why, and when SQL Server uses statistics and how this new feature will help improve performance.

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.

Speaker

Thomas LaRock is a Head Geek at SolarWinds and a Microsoft Certified Master, Microsoft MVP, a VMware vExpert. He has over 15 years’ experience in the IT industry in roles including programmer, developer, analyst, and database administrator.

Thomas LaRock's Sessions

From Here to Azure

Database Design: Size DOES Matter

Cardinality Estimates in Microsoft SQL Server 2014

Monitoring Databases in a Virtual Environment

Database Design: Size Does Matter!