Join the Baltimore SQL Server Users Group to expand your knowledge and network! We hold free monthly meetings focusing on SQL Server DBA, Development and Business Intelligence topics. Our meetings are typically on the third Tuesday of the month from 6:30 PM to 8:30 PM in Columbia, MD. Please join us for one of our upcoming meetings.
The presentations and code demos from our meetings are available for download on GitHub (https://github.com/bssug/PresentationDownloads). When you click on the GitHub link, you will see the list of monthly presentations and code in a .zip file. Click on the one you want, and a new page will be displayed. Click the Download button.
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 President/Founder of SQLSkills.com. Kimberly’s an author, consultant, and top-rated speaker having spoken at PASS, TechEd, SQLintersection, and numerous other events around the world; she’s also been a Microsoft SQL Server MVP for over 10 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.
Full Bio: http://www.sqlskills.com/about/kimberly-l-tripp/
SQL Server MVP since 2002