Stored Procedure Optimization Techniques - Kimberly L. Tripp of SQL Skills

We are very excited to have Kimberly L. Tripp of SQL Skills giving the following presentation

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