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.
-
Updated
Dec 31, 2025 - TSQL
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.
SQL Server performance tuning case studies with before/after and T-SQL 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."