About Show #418
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!
Kimberly Tripp is a SQL Server MVP and a Microsoft Regional Director, and has worked with SQL Server since 1990. Kimberly worked for Microsoft – on the SQL Server team – and left in 1995 to start SQLskills where she writes, consults, speaks, and teaches classes on SQL Server. Her primary focus is architecture, design, and performance tuning with her primary goal of helping customers design the RIGHT solutions to their problems.