Stored Procedure Optimization Techniques - Kimberly L. Tripp (Remote)
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).
Kimberly (SQLskills President/Founder) is 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
Sponsor: Robert Half Technology (http://www.roberthalf.com/technology/)
*** NOTE: We will meet on the first floor this month, in the Big Sur room. ***
2700 Gateway Oaks Drive (http://maps.google.com/maps?f=q&hl=en&q=38.615650,-121.514920) is located in the Sutter Health business park at the northeast corner of the intersection of Gateway Oaks Drive and West El Camino in Sacramento. The 2700 building is at the back of the complex; you can see I-5 from the parking lot. Enter the building from the parking lot side, not the courtyard side. Once inside the building, take the stairs or elevator to the second floor, then enter Suite 2600. In the reception area, check the monitor to find our room for the evening and then proceed to that room.
Claim the event and start manage its content.I am the organizer