SQL Server Performance Tuning
Find and fix what's actually slow: execution plans, index design, SARGability, parameter sniffing, and a Telerik reporting triage playbook — practical tuning with runnable T-SQL.
Sign in with your name + email to track your progress through the course — your friends can too, each with their own.
1
Measure First: Finding What's Actually Slow
Wait stats, query store, and extended events — find the real bottleneck before you touch anything.
5 lessons
2
Reading an Execution Plan
Actual vs estimated plans, operators, and the handful of red flags that matter.
5 lessons
3
Index Design That Actually Helps
Clustered vs nonclustered, covering indexes, and the missing-index DMVs — used carefully.
6 lessons
4
SARGability and Query Anti-Patterns
Rewriting queries so SQL Server can actually use your indexes.
6 lessons
5
Parameter Sniffing, Statistics, and 2022 Features
Why the same query is fast for one value and slow for another, and the 2022 fixes for it.
6 lessons
6
Reporting Workloads and a Telerik Triage Playbook
Diagnosing a slow Telerik report end to end: dataset query, grid paging, and export.
6 lessons