Parameter Sniffing: A Simple Example
A while ago, I was working with a client who was experiencing performance issues on SQL Server 2019.
We quickly isolated the problematic procedure and they asked ’this normally runs fine, why is this a problem now?’ A fair question…