Go offline with the Player FM app!
Tuning SQL Server Stored Procedures with Kim Tripp
Manage episode 323659335 series 19264
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!
983 episodes
Manage episode 323659335 series 19264
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!
983 episodes
All episodes
×Welcome to Player FM!
Player FM is scanning the web for high-quality podcasts for you to enjoy right now. It's the best podcast app and works on Android, iPhone, and the web. Signup to sync subscriptions across devices.