When it comes to SQL Server performance issues, parameter sniffing is one of those topics that both frustrates and fascinates. It’s often subtle, intermittently problematic, and notoriously tricky to explain to people who aren't knee deep in query pl...
