Precon training -  Execution plans in depth

Hugo Kornelis

Get ready to dive deep into execution plans and master the art of precon training in this in-person event!

Ara Institute of Canterbury

Execution plans in depth: Execution plans in SQL Server remain crucial even when working with advanced analytics platforms like Fabric, Azure Synapse or Power BI because they provide detailed insights into how queries are executed, enabling you to optimise performance and ensure efficient use of resources, 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 pre-con session, 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. In short: After this pre-con, you will be better prepared to look at execution plans, find the spot 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 pre-con is for you.

Our {communityGuidelinesLink} describe the sort of content we prohibit on Eventbrite. If you suspect an event may be in violation, you can report it to us so we can investigate.

To report other categories of prohibited or illegal content, submit {link}

Precon training - Execution plans in depth

More events from Hugo Kornelis

Discover more events from Hugo Kornelis, from Business to other experiences you might love.

Precon training - Execution plans in depth

More events from Hugo Kornelis

Discover more events from Hugo Kornelis, from Business to other experiences you might love.

You might also like...

Browse more events with different dates, prices, and formats to find your next great experience.