Stored Procedure Optimization Techniques

The August meeting for the Ohio North Database Training user group will be on Tuesday, August 3, 2021. This will be a virtual event and our featured speaker will be Kimberly Tripp, President/Founder of SQLskills.

5PM EDT: online meeting begins with a social hour. This is an unstructured hour where you can join us to catch up and meet other members of the group before the session starts.

6PM EDT: Updates and announcements, followed by Kimberly's session.

Kimberly's session covers optimization techniques for stored procedures - this is a great session whether you are a developer, DBA, or anything in between! Please review the abstract below for more details.

We hope to see you there!

*Please note, we will be using Microsoft Teams for this month's meeting. Plan to join a few minutes early just to make sure you do not have any issues.

Session Abstract:
Kimberly will discuss stored procedure caching and the potential for performance problems due to a problem known as parameter sniffing. There are some common solutions and while they can drastically improve performance, they can also cause other problems. Sometimes a hybrid solution is needs, from this session, you’ll know the best way to write procedures so that stable requests are cached and unstable requests are not (giving you the most optimal performance without wasting resources).

Speaker Bio:
Kimberly’s an author, consultant, and top-rated speaker having spoken at PASS, TechEd, SQLintersection, and numerous other events around the world; she was also a Microsoft SQL Server MVP for over 15 years. She has over 25 years of experience designing and tuning SQL Server solutions with a focus on optimizing procedural code, indexing strategies, statistics, and partitioning. When she's not tuning SQL servers, she's diving and photographing all sorts of underwater critters such as frogfish with her husband, Paul S. Randal.

Email: Kimberly@SQLskills.com
Website: https://www.SQLskills.com
Full Bio: https://www.sqlskills.com/about/kimberly-l-tripp/
Blog: http://www.SQLskills.com/blogs/Kimberly
Twitter: http://twitter.com/KimberlyLTripp
SQL Server MVP since 2002