SQL Server performance tuning case studies with before/after and T-SQL scripts.
-
Updated
Sep 17, 2025 - TSQL
SQL Server performance tuning case studies with before/after and T-SQL scripts.
Demonstrates the impact of parameter sniffing on execution plans and performance in SQL Server. Compares simple SPs, dynamic SQL, and OPTION(RECOMPILE to mitigate performance issues.
Oracle performance tuning case studies with before/after and PLSQL scripts.
Add a description, image, and links to the parameter-sniffing topic page so that developers can more easily learn about it.
To associate your repository with the parameter-sniffing topic, visit your repo's landing page and select "manage topics."