Welcome to the Columbus SQL Server Users Group

Our local meetings are free and open to all! We meet the second Thursday of every month.



DUE TO THE CURRENT COVID-19 SITUATION, ALL GROUP MEETINGS WILL BE VIRTUAL UNTIL A FURTHER NOTICE.



 

Upcoming Meeting


Thursday, Sept 10th 2020 @ 6:30 PM


Stored Procedure Optimization Techniques


Kimberly Tripp



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 needed, 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).



Bio


Kimberly Tripp is 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


RSVP HERE
There are limited number of GoTo Meeting seats, registration is required!
All of the connection information is on the RSVP page.

Back to Top
cage-aids
cage-aids
cage-aids
cage-aids