Simple Parameterization and Trivial Plans — Part 1
SQL Performance
MARCH 22, 2022
In this first part, after a quick introduction, I look at the effects of simple parameterization on the plan cache. There are also options like sp_executesql , stored procedures, and functions. Let’s look at an example, using the Stack Overflow 2010 database on SQL Server 2019 CU 14. Shell Plans. sp_configure.
61 
Let's personalize your content