Execution plan reuse is one of the most misunderstood aspects of SQL Server. While it serves us well 99.99% of the time, it is very easy to trip up when parameter sniffing results in performance problems.

In this session, we will thoroughly dissect how plan reuse works, discuss parameter sniffing, and the many potential solutions available to resolve it. We will examine the many poor solutions that are found on blogs and web pages all over the internet and why applying a quick-fix may result in long-term performance headaches if not thoroughly researched prior to implementation.