SQLBits encompasses everything from in-depth technical immersions to the enhancement of valuable soft skills. The full agenda will be announced in the spring; in the meantime check out the timetable and content we cover below.
2024 Training Days
Presenting 2024’s selection of training days, encompassing a deep dive into a range of subjects with some of the best data trainers in the world.
- 08:00 Registration opens and breakfast served.
- All training days run simultaneously across the venue from 09:00 – 17:00 with co-ordinated breaks.
- All training days include regular refreshment breaks and a lunch stop to rest, recharge, and chat to fellow delegates.
- No evening events planned, but if you’re staying over the night beforehand, why not join us in the Aviator on Monday night to meet the training day speakers for an informal drinks reception.
Execution Plans in Depth
Description
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. This will increase your understanding on why the optimizer picks a plan, and what you can do to make it pick a better plan.
Aside from explaining all of the common operator, we will also touch on several operators that were introduced or modified in the newer versions of SQL Server, and preview some enhancements that have been announced for future versions.
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.
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. This will increase your understanding on why the optimizer picks a plan, and what you can do to make it pick a better plan.
Aside from explaining all of the common operator, we will also touch on several operators that were introduced or modified in the newer versions of SQL Server, and preview some enhancements that have been announced for future versions.
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.
Learning Objectives
Previous Experience
Tech Covered
performance