Next Meeting: Thu, Apr 07 2016
April 2016 Meeting
Event Type: In-Person
Online Meeting URL: None
Join us as Kimberly Tripp with SQL Skills joins us to present "Stored Procedure Optimization Techniques".
UTC : Thu, Apr 07 2016 23:00 - 01:00
Event Time : Thu, Apr 07 2016 18:00 - 20:00 Central Daylight Time
Your Local Time: Thu, Apr 07 2016 23:00 - 01:00
2901 S 84th St #16
Direction: Dino's Eastside Grill is located at the SW corner of 84th and Van Dorn.
Stored Procedure Optimization Techniques
Kimberly Tripp, Founder/President/Owner SQLskills.com
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).
Kimberly L. Tripp is the founder/co-owner (with her husband, Paul Randal) of SQLskills.com, a world-renowned training and consulting company. She worked for Microsoft University and on the SQL Server team in the early '90s but left to consult in 1995. Since then, she has been consulting with a variety of clients. Kimberly is an accomplished writer and presenter with numerous top-speaker awards over the years; she is also a SQL Server MVP. You can read more at SQLskills.com.