Tuning SQL Server Stored Procedures with Kim Tripp

How do you tune your stored procedures? While visiting Kim Tripp at her home, Richard chats with her about her approach to turning stored procedures. The conversation starts out focused on query plans, which applies to all sorts of things, but stored procedures have some special foibles around parameter sets and recompilation - there are good techniques and bad! Kim also digs into session parameters. If you've ever had a stored procedure that performed great in Management Studio but sucked out in the world, there's a good chance the session configurations are different. Also listen for a quick discussion on stored procedure techniques that can help fight SQL Injection attacks!

Episode 418 of the RunAs Radio podcast, hosted by Richard Campbell, titled "Tuning SQL Server Stored Procedures with Kim Tripp" was published on April 29, 2015 and runs 37 minutes.

April 29, 2015 ·37m · RunAs Radio

Summary

How do you tune your stored procedures? While visiting Kim Tripp at her home, Richard chats with her about her approach to turning stored procedures. The conversation starts out focused on query plans, which applies to all sorts of things, but stored procedures have some special foibles around parameter sets and recompilation - there are good techniques and bad! Kim also digs into session parameters. If you've ever had a stored procedure that performed great in Management Studio but sucked out in the world, there's a good chance the session configurations are different. Also listen for a quick discussion on stored procedure techniques that can help fight SQL Injection attacks!

Episode Description