This event has ended. View the official site or create your own event → Check it out
This event has ended. Create your own
View analytic
Tuesday, May 23 • 11:30 - 12:30
Cardinality Estimates in SQL Server

Log in to save this to your schedule 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 has worked in numerous IT roles over the past 15 years with much of his career focused on database administration, leading to his role as Technical Evangelist for Confio. While at Confio, his research and experience helped to create the initial versions of the software now known as SolarWinds Database Performance Analyzer. LaRock joined the SolarWinds family through the acquisition of Confio in 2013. His many Microsoft accreditations include SQL Server MVP, MCSM, MCM, MCT, MCITP, MCTS, MCDBA and MCP... Read More →

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