Techorama 2017 has ended
Back To Schedule
Tuesday, May 23 • 11:30 - 12:30
Cardinality Estimates in SQL Server

Log in to save this to your schedule, view media, leave feedback and see who's attending!

Feedback form is now closed.
SQL Server 2014 introduced a new cardinality estimator (CE). 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. We will discuss the differences between the legacy and new CE, discuss examples, see the CE in action, and discuss tips and tricks for you to deploy in order to make certain your queries are getting the best execution plans.

avatar for Thomas LaRock

Thomas LaRock

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

Tuesday May 23, 2017 11:30 - 12:30 CEST
Room 11