Saskatoon SQL Server User Group

Next Meeting

Friday,

August

31

Meeting 6 of 2018

Meeting number 6 of 2018 is a remote presentation as done by Kimberly Tripp.

The subject will be:
Stored Procedure Optimization Techniques


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

PASSChapterLogo.jpg

Upcoming PASS Sponsored Events:

  • ONLINE EVENTS:

  • IN PERSON EVENTS:

  • 24 hours of PASS - here

    PASS BA Days - here
    BA Marathon - herePASS affiliated conferences - here

    And can't forget SQLSaturday (aka mini-Summit) - here

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