Name: Edward Pollack: Parameter Sniffing: Everything You Have Been Told is Wrong!
Start: 2023-09-14T12:00:00-05:00
End: 2023-09-14T13:00:00-05:00

Join us for a Lunch and Learn!

**Parameter Sniffing: Everything You Have Been Told is Wrong!**

**SUMMARY**
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.

Kristina Mishra

(Virtual) KCSSUG

Azure Data Tech Groups

Provides "call for speakers" capabilities for community user groups.

Sessionize

Technology

Software Development

SQL Server

Database Development

Database Applications

SQL Integration Services

SQL Azure

Database Professionals

Advanced SQL Server

Microsoft Azure

Data Management

Data Analytics

Ed Pollack has 20+ years of experience in database administration and architecture, which has developed his passion for performance optimization, database design, and security. He has spoken at many SQLSaturdays, 24 Hours of PASS, and PASS Summit. This led him to organize many SQL Saturday and other Microsoft data platform events. Ed is a Microsoft Data Platform MVP.




In his free time, Ed enjoys video games, traveling, cooking exceptionally spicy foods, and hanging out with his amazing wife and sons.

Edward Pollack