Sacramento SQL Server User Group

Next Meeting

Wednesday,

March

02

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

  • Patrick Hays Learning Center (map)
  • 2700 Gateway Oaks Drive, Suite 2600
  • Sacramento, CA 95833
  • 6:00 PM to 8:00 PM
  • RSVP via Meetup

n this remote presentation, 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 L. Tripp, SQLskills.com President/Founder, has been a Microsoft SQL Server MVP and a Microsoft Regional Director for over 10 years; she's an author, consultant, and top-rated speaker having spoken at PASS Summit, TechEd, SQLintersection, and numerous other events around the world. She has over 20 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: Kimberly@SQLskills.com 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

Featured Presentation:

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

Kimberly Tripp, Founder/President/Owner SQLskills.com

In this remote presentation, 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).

About Kimberly:
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 1990s but left to consult in 1995. Since then, she has been training, consulting, and speaking on a number of SQL Server areas with performance tuning, VLDBs, and optimization her most common topics. 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. In her free time, and with her husband, Paul Randal, she likes diving, searching for critters, and underwater photography!

Meeting Schedule and Structure

The Sacramento SQL Server User Group meets the first Wednesday of every month. Most meetings will have a presentation, while others are open group sessions which allow attendees to discuss SQL Server questions, issues and news as a group.

We start each meeting with some time to network and get situated. Unless otherwise noted, the schedule for each meeting will be:

6:00 PM - 6:15 PM: Mingle/networking, get food & beverages, presentation setup
6:15 PM - 6:30 PM: Group announcements, agenda, introduce speaker
6:30 PM - 7:30 PM: Presentation
7:30 PM - 8:00 PM: Post-meeting discussions

Announcements

SQLSaturday Sacramento 2017 (SQLSaturday #650, #sqlsatsac):
SQLSaturday Sacramento 2017 (SQLSaturday #650) was July 15, 2017.
http://www.sqlsaturday.com/650/EventHome.aspx

Our Sponsors

PASSChapterLogo100.jpg

 

Back to Top
cage-aids
cage-aids
cage-aids
cage-aids