Parameter Sniffing 101: Why Does SQL Get A Bad Plan

The May Ohio North Database Training user group meeting will be held on June 3rd, 2025 at 5:00PM. This will be a HYBRID event with Jay Rasch joining us in person.

You're welcome to come meet in-person at our meeting location, the offices of Improving at

6000 Freedom Square Dr,
Unit 110,
Independence, OH 44131

Teams Link if anyone needs it after RSVP-ing for in person.

Agenda:

5:00 PM EST: Online and in-person meeting begins with a social hour. This is an unstructured hour where you can join us to catch up and meet other group members before the session starts. There will be food brought in for in-person attendees.

6:00 PM EST: Updates and announcements, followed by our feature presentation. See below for presentation details.

7:30 PM EST: Optionally after the main presentations, the in-person crowd may go out for snacks and drinks at a local establishment.

We hope to see you there!

Session Abstract

SQL Server tries to reuse query plans for good for good but sometimes it inadvertently uses them for evil. Have you ever wondered why your queries are sometimes fast and sometimes slow without any clear reason? A likely cause is parameter sniffing. This session will teach you about why SQL sometimes gets a bad plan for your query, patterns to watch out for and examples of some possible solutions.

*Please note, that we will be using Microsoft Teams for the online portion of this meeting. You may want to join a few minutes early to ensure you do not have any issues. If you are attending in person, there are large TVs at the office, and you do not need to bring a laptop or use Teams.