SQL Server Query Tuning Workshop on June 17 - 18, 2025
Key Concepts Covered in this Course
- Query Processing Fundamentals
- Index Tuning Strategies
- Statistics & Plan Caching
Klaus Aschenbrenner
Microsoft Certified Master for SQL Server
I work with Microsoft SQL Server for more than 25 years, and I provide with my company SQLpassion consulting and training services around the whole world.
Since 2012 I’m also a Microsoft Certified Master for SQL Server.
Course Description
Are you desperately searching for a way to enhance your SQL Server skills – especially when it comes to query tuning? When you look at execution plans, do you understand how to interpret and analyze them? Are your queries slow? And yet you don’t know how to fine tune them and improve them?
If so, join my SQL Server Query Tuning Workshop, where you’ll learn everything you need to know to master SQL Server query tuning and boost your database performance.
Amazing Course
“Anyone faced with the task to implement queries on complex ERP data structures – for reporting, providing views, or for statistical analysis – comes quickly to its limits without knowledge of the operation of SQL Server. The workshop provides an excellent insight into the technical world of SQL Server, explained with many examples of queries and their optimization.”
Ina from Oberhaching, Germany
Course Details
Course Duration
2 Days
Course Price
EUR 1490 incl. 20% VAT until May 31
EUR 1790 incl. 20% VAT from June 1
Course Level
Beginner & Intermediate
Agenda & Breakdown
Day 1 – Query Processing
- Execution Plans
- Overview
- Input Trees
- Estimated Execution Plan
- Actual Execution Plan
- How to access your data through Indexes
- Clustered Index
- Non-Clustered Index
- Index Scans
- Index Seeks
- Physical Operators
- Data Access Operators
- Join Operators
- Aggregation Operators
- Spool Operators
- Halloween Protection
Day 2 – Index Tuning
- Index Tuning Strategies
- Search Arguments
- Bookmark Lookups
- Tipping Point
- Index Intersection
- Filtered Indexes
- Indexed Views
- Statistics
- Auto Create
- Auto Update
- Fill Factor
- Statistics Analysis
- Multi-Column Statistics
- Plan Caching & Parameter Sniffing
- Adhoc Query Caching
- Parameterization
- Optimize for Adhoc Workloads
- Recompilations
- Plan Guides
Date & Location
June 17 – 18, 2025
EUR 1490 incl. 20% VAT until May 31, 2025
EUR 1790 incl. 20% VAT from June 1, 2025
Location: Online Live Class (Microsoft Teams)
Course Language: English
