Execution Plans in Depth (Hugo Kornelis)

The Data Community Austria is an independent, non-profit organization (NPO) dedicated to supporting, educating, and promoting the global Microsoft SQL Server and Azure community. The organization is run by and for the community, made up of database administrators and developers, application developers, Business Intelligence and IT professionals, executives, consultants, educators, instructors, students, vendors, and many others who work with or use Microsoft Azure, SQL Server and Business Intelligence technologies.

Data Community Austria

Master SQL Server execution plans! Learn inner workings, operator behavior, and tuning tips to fix slow queries effectively.

JUFA Wien City

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. Your trainer: Hugo Kornelis (https://www.linkedin.com/in/hugokornelis/)

Execution Plans in Depth (Hugo Kornelis)

More events from Data Community Austria

Discover more events from Data Community Austria, from Science & Tech to other experiences you might love.

Still looking for the right event?

Explore all events in Wien and filter by date, category, and more to find the perfect fit.

Execution Plans in Depth (Hugo Kornelis)

More events from Data Community Austria

Discover more events from Data Community Austria, from Science & Tech 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.

Still looking for the right event?

Explore all events in Wien and filter by date, category, and more to find the perfect fit.