This repository documents real-world SQL Server performance tuning work.
Each folder is a case study with:

• A short write-up (problem → analysis → fix → result)
• Before/After screenshots (plans/metrics)
• Repro and scripts used

⚠️ Run on non-production first. Review and adapt scripts to your environment.

Here are some highlights from performance tuning cases:

This case study explores different methods of calculating Running Totals in SQL Server and compares their performance.
Six approaches were tested, from basic JOIN and Subquery methods to more advanced techniques like Window Functions.

Execution Plans

👉 View scripts

👉 Read full case study

Before / After

👉 Read full case study

You can browse all case studies in the repository:

👉 Full Case Study Archive