SQL Server Parameter Sniffing: Why a Query Is Fast in SSMS but Slow in the App
Why the same SQL Server procedure is fast for one value and painfully slow for another, or fast in SSMS but slow in your application, how to confirm it is parameter sniffing, and six fixes with when to use each.
