Press "Enter" to skip to content

Now where did THAT estimate come from? – Hugo Kornelis – 11th April 2019

Robert French 2
Hugo Kornelis

The SQL Server Query Optimizer makes its plan choices based on estimated rowcounts. If those estimates are wrong, the optimizer will very likely produce a poor plan. And there’s nothing you can do about it.

Or is there?

In this session, you will learn exactly where these estimates come from. You will gain intimate knowledge of how statistics are built and maintained and how they are used to estimate row counts. But you will also learn how filters and joins influence those estimates.

Though the focus of this session is on understanding the causes of bad estimates, you will also learn ways to fix the problems and get better estimates – and hence, better performing queries

Hugo Kornelis is an established SQL Server Community expert. He writes, blogs, speaks, tech edits, and researches, focusing mostly on SQL Server performance and execution plans. He was the technical editor for the third edition of Grant Fritchey’s “SQL Server Execution Plans”. In 2018 he started a project to document all behaviour of SQL Server execution plans at his website, “the SQL Server Execution Plan Reference” (https://sqlserverfast.com/epr)

When not working for the community, Hugo is busy at his day job: freelance database developer./consultant. Hugo has 20 years of experience on SQL Server in various roles. He has a strong database design background but has since specialized into query tuning and execution plans.

Interested in seeing this session ? Then sign up at our meetup page – https://www.meetup.com/Glasgow-SQL-User-Group/events/258881960/

  1. philip Smith philip Smith

    HI

    just wondering what level this is aimed at entry? advanced?

    • Robert French Robert French

      Hi Philip thanks for the question, looking the session abstract on Hugo’s site the target audience is “Experienced database developers and DBAs.” The session is not an entry level, I would suggest that attendees would benefit if they are aware of indexes and query plans. From what I can see the session is focusing on query plans and looking at how SQL server find the estimated number of rows figure that is displayed in query plans.

Leave a Reply

Your e-mail address will not be published. Required fields are marked *