header

 
NEXT MEETING:
May 24, 2018 6:30 PM

 
LOCATION:
PacificSource Health Plans
13010 SW 68th Parkway, Suite 140
Tigard, OR 97223

As you are facing the long side of the building – the main entrance is to your left. To the right, around the corner at the end of the building is a door which leads to the hallway where the new room is, and the first door on your right is “it”.
  PRESENTATION:
Stored Procedure Optimization Techniques with Kimberly Tripp

DESCRIPTION
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).

BIO
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.
 

 


CORPORATE SPONSORS

PacificSource PASS Chapter Logo


copyright ©2017, Portland SQL Server User Group and pdxssug.com all rights reserved.
Redistribution of any portion of this site is forbidden without prior written permission.