Joe Sack Tunes Queries in SQL Server!

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

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

Your partner wants profit. You want freedom. Now what? 22 min · 16 Sep 2026 · The Optometry Success Podcast

Board of County Supervisors Meeting - Work Session - Sep 15, 2026 3h 17m · 15 Sep 2026 · Prince William County Board of Supervisors

Finance and Budget Committee - Sep 15, 2026 1h 43m · 15 Sep 2026 · Prince William County Finance and Budget Committee

Sept. 15, 2026 Board of Supervisors Meeting 8h 46m · 15 Sep 2026 · Fairfax County Board of Supervisors

The Art of True Happiness | Dr. Arthur Brooks 2h 49m · 14 Sep 2026 · Huberman Lab

Report any issue

Source

Recorded26 Sep 2012

Publisherfeeds.simplecast.com ↗

Handlerec:11841352

Show notes

Richard chats with former PFE Joe Sack about his work helping queries go faster in SQL Server. Joe talks about his techniques for figuring out what to fix as well as how to fix it, starting with studying wait statistics in dynamic management views - SQL Server knows what it's waiting for! From there the conversation digs into the ways that SQL Server fools itself to perform badly, including cardinality estimate issues and other problems with statistics. Joe also looks at the potential of column store indexes in SQL 2012 - still new cool stuff to come in SQL Server!

Ask this episode

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

Sign in