SQL Server Query Tuning Fundamentals
Key Concepts Covered in this Course
- SQL Server Query Execution
- Data Access Paths
- Understanding Execution Plans
- Execution Plan Operators
Klaus Aschenbrenner
Microsoft Certified Master for SQL Server
As the CEO and Founder of SQLpassion, I bring over 25 years of expertise in providing SQL Server & PostgreSQL consulting services across Europe. Specialized in performance tuning, troubleshooting, and high availability,
I enable organizations to optimize their SQL Server & PostgreSQL environments for better scalability and reliability. My work focuses on empowering teams to implement effective solutions tailored to their unique challenges.
Course Description
If you have a database driven application which reacts very slowly when the data increases, then you are right in this webinar! In this live training you will learn how you can tune SQL Server Queries with the information available inside an execution plan. You will see how SQL Server retrieves data from the database files, how SQL Server can join resultsets, and how you can react with indexes if you are in performance troubles.
Amazing Course
“My day-to-day writing of SQL has gone up a level – I am able to finely tune individual statements or underlying database objects to get the kind of query plan I want. Moreover I know now what sort of plan I am looking for. I have been already able to use this knowledge to address performance issues that came up this week in capacity testing.”
Arun from London, United Kingdom
Course Details
Course Duration
1 Day
Course Price
EUR 690 incl. 20% VAT
Course Level
Beginner
Agenda & Breakdown
- 🌐 Data Access & Index Fundamentals
- How SQL Server reads data using Indexes
- Heap Tables vs. Clustered Indexes – and why it matters
- Non-Clustered Indexes, Covering Indexes, and Lookups
- Index Seeks vs. Index Scans (and when each is good or bad)
- ✨ Execution Plans Made Practical
- How SQL Server chooses an Execution Plan
- Estimated vs. Actual Execution Plans
- How to spot:
- Bad Estimates
- Missing or inefficient Indexes
- Expensive Operators
- 🚀 Core Query Operators
- Data Access Operators
- Scans
- Seeks
- Lookups
- Join Operators
- Nested Loops
- Merge Joins
- Hash Match
- Aggregation Operators
- Stream Aggregate
- Hash Aggregrate
- Data Access Operators
- 🎓 Advanced Performance Pitfalls
- Halloween Protection explained
- Why UPDATEs and DELETEs can suddenly become slow
- How SQL Server protects data – and what is costs
This one-day live training is built for DBAs, Developers, and Consultants who want faster SQL Server performance through smarter indexing. No deep theory, no prerequisites – just practical indexing knowledge based on standard T-SQL queries and stored procedures.
February 9, 2026
EUR 690 incl. 20% VAT
Cancellation Fee: 100%
Course Language: English
Location: Online Live Class from 09:00am to 05:00pm (Microsoft Teams)
🔐 Secure Your Spot Today!
Don’t miss this opportunity to elevate your SQL Server skills and become a SQL Server expert. Secure your spot now and embark on a transformative learning journey!
