Tuning SQL Server Stored Procedures with Kim Tripp

episode

RunAs Radio not yet transcribed

▲ 0

Transcript

This episode hasn't been transcribed yet Upvotes decide what gets transcribed next — 0 so far. Sign in to upvote

Related

recent transcribed audio

AWP: Beyond the Exam Room: Purpose, Myopia, and Population Health 54 min · 17 Sep 2026 · EyeCode Media

Essentials: How to Assess & Improve All Aspects of Your Fitness | Dr. Andy Galpin 35 min · 17 Sep 2026 · Huberman Lab

#502 – Psychiatry, Insane Asylums, Mental Illness, ECT, Lobotomies, Freud & Jung 3h 43m · 17 Sep 2026 · Lex Fridman Podcast

September 16, 2026 PC - Sep 16, 2026 1h 50m · 16 Sep 2026 · Fairfax County Planning Commission

Planning Commision 09/16/2026 - Sep 16, 2026 56 min · 16 Sep 2026 · Prince William County Planning Commission

Western Loudoun Rural Uses and Standards PCZOC Ad Hoc Meeting 2 - Sep 16, 2026 4h 45m · 16 Sep 2026 · Loudoun County Board Committees and Advisory Boards

Report any issue

Source

Recorded29 Apr 2015

Publisherfeeds.simplecast.com ↗

Handlerec:11841217

Show notes

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!

Ask this episode

“What did the council decide on item 42?” — answered with the speaker and the moment.

Sign in