4.6 Tuning usp_SearchUsers
In my workload, this is the most resource-intensive proc – but it doesn’t actually have parameter sniffing. It has the opposite problem: it’s building unsafe, unparameterized dynamic SQL vulnerable to SQL injection. When we fix it by properly parameterizing the dynamic SQL, we actually introduce parameter sniffing – so let’s fix that too while we’re at […]
To access this incredible, amazing content, you gotta get Mastering Parameter Sniffing – Live Classes + Instant Replay, 1 Year Access, Mastering Parameter Sniffing – Instant Replay Recordings Only, 1 Year Access or Recorded Class Season Pass, or log in if you already shelled out the cash.