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.
Index Analysis and Performance Improvement
Description
It is not always the wrong configuration of a Microsoft SQL Server which causes bad running applications. Quite often you’ll find design problems in the database, bad indexes or a mix of all together.
This workshop shows the diverse types of indexes you can use in an OLTP-System. Beside the basic stuff you’ll get introduced to different dmv’s which give you the chance to analyse and rate existing indexes and execution plans.
Equipped with the basics of row based indexes and the available tools, we will walk through different real world examples and build solutions for common problems based on wrong indexing and/or database design.
Fasten your seat belts for these topics which will be handled in detail:
- HEAP / Clustered Index / non clustered Index – basics of indexing
- What key is an ideal candidate for a clustered index?
- Analysis of workloads is an essential part for a good determination
- Importance of statistics for performant queries
- Tools for analysis of index performance and index conditions
- DML-Operations and its side effects to indexes
- Understanding and reading execution plans
- Difference of the physical JOIN operators
- Problem solution with partitioned views
- SARGable queries
- Usage of correct data types for a good performing execution of queries
- Foreign keys and it’s correct indexing
- Impact of different collations on queries
- Ascending key Problem
Pre-requisites
None - it is a 0 - 300 workshop. Attendees have to bring their computer. The demos will be provided for download at the workshop day!
Laptop Required:Yes
- Spec: "SQL Server >= 2012 , SQL Server Management Studio >= 2016 (e.g. 17.3)"
- Software: None
- Subscriptions: No
Learning Objectives
Previous Experience
Tech Covered
performance