Iowa Data Professionals-DSM: April Virtual Meeting with Edward Pollack

This meeting will be 100% online -- there will be no in person meetings at this time

Connection Software: Microsoft Teams
The Des Moines chapter of the Iowa Data Professionals (IDPA) will meet the Monday before the 2nd Wednesday of the new month. The 2nd Wednesday of the new month is reserved by Quad City PASS.
Meetup Organizers will start the Microsoft Teams meeting at 5:30 PM, Central Time (22:30 UTC), and will then admit attendees into the remote meeting.
Please connect, eat your dinner and network with other data professionals until the meeting is called to order.
At 5:50 PM Central Time (23:00 UTC) our Local Group Leader will call the meeting to order with brief announcements.
At 6:00 PM Central Time (23:00 UTC) we will introduce the featured speaker, Edward Pollack.
Session Information:
Title: Parameter Sniffing: Everything You Have Been Told is Wrong!
Description:
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.