Stored Procedure Optimization Techniques - Kimberly L. Tripp (Remote)

Dec 6, 2017 · Sacramento, United States of America

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.

Email: [masked]
Website: http://www.SQLskills.com
Full Bio: http://www.sqlskills.com/about/kimberly-l-tripp/
Blog: http://www.SQLskills.com/blogs/Kimberly
Twitter: http://twitter.com/KimberlyLTripp
SQL Server MVP since 2002

Sponsor: Robert Half Technology (http://www.roberthalf.com/technology/)

Meeting location:

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

Event organizers
  • Sacramento SQL Server User Group

    The Sacramento SQL Server User Group is a local chapter of the Professional Association for SQL Server (PASS). The mission of PASS is to empower data professionals who leverage Microsoft technologies to connect, share, and learn through networking, knowledge sharing, and peer-based learning. We meet the first Wednesday of each month (6PM to 8PM) to discuss anything SQL Server.  Additionally, we host a SQLSaturday event every July. We are new to Meetup.com, but we are not a new group; we've been meeting si

    Recent Events
    More

Are you organizing Stored Procedure Optimization Techniques - Kimberly L. Tripp (Remote)?

Claim the event and start manage its content.

I am the organizer
Social
Rating

based on 0 reviews