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.
SQL Server Query Plans --- Reuse or Recompile?
Description
What determines when a plan is reused? When is it better to
recompile? Reusing an inappropriate plan cause a huge reduction in query
response time. On the other hand, recompiling a frequently run query every time
it’s executed can also cause big performance problems.
In this seminar, we’ll discuss how SQL Server decides to recompile
or reuse an existing plan, and how you can tell if that’s a good choice. We’ll
also look at how you can ‘encourage’ SQL Server to do what you want it to do.
The seminar includes extensive demonstrations that illustrate
the details of SQL Server plan caching and recompilation, as well as the
internals of the plan cache and the metadata available for examining its
contents.
This seminar will be presented on SQL Server 2014 and cover
features specific to that version, but most of the information is relevant to
SQL Server 2012 and SQL Server 2008 as well.
Learning Objectives
Previous Experience
Tech Covered
performance