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.
Performance Tuning with Indexes: Internals and Best Practice
Description
Indexes allow SQL Server to access your data in the most efficient manner. Understanding exactly how our indexes are structured and stored internally can give you a deeper understanding of what indexes will be useful for your queries. Knowing how indexes are useful can allow us to generalize some best practice
recommendations. In this seminar we’ll look at the following topics:
.
Basic Index Structures
Clustered vs nonclustered
Unique vs non-unique
Included columns
Tools for Exploring Index Structures
Index maintenance
Page splits
Fragmentation and Defragmentation
Index Design Considerations
AND’s/ OR’s
JOIN’s
Composite Indexes
Best Practice Guidelines
Columnstore Index Storage
Columnstore Index Guidelines
Learning Objectives
Previous Experience
Tech Covered
performance