Hugo Kornelis is an established SQL Server communiity expert who spends a lot of time at various conferences. He is also a blogger, technical editor of a variety of books, and Pluralsight author. He was a SQL Server MVP from 2006 to 2016. When not working for the community, he is busy at his day job: freelance database developer/consultant. Hugo has almost 20 years of SQL Server experience in various roles. He has a strong database design background, but also loves to write and tune complex queries.
PRECON: Execution Plans in depth
For troubleshooting slow queries, looking at the execution plan is a good starting point. But sometimes, just looking at the plan does not help. Sometimes you need to dig deeper.
In this full-day workshop, you will learn everything you need to be take your understanding of execution plans to the next level. For almost every operator you can encounter in an execution plan, we will look at the inner workings, and look at properties that can affect their performance. We will also look at how operators in a plan interact with and affect each other.
Aside from explaining all of the common operators, we will also touch on several operators that were introduced or modified in the newer versions of SQL Server, and preview some changes that have been announced for future versions.
In short: After this workshop, you will be better prepared to look at execution plans, find the spo where it hurts, and then rewrite your query to get a faster execution plan.
If you have seen some execution plans but feel you need to bring your understanding to the next level, then this workshop is for you.Precon
Now Where Did THAT Estimate Come From?
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 cause of bad estimates, you will also learn ways to fix the problems and get better estimates - and hence, better performing queries.