Joe Sack Tunes Queries in SQL Server!

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!

Episode 283 of the RunAs Radio podcast, hosted by Richard Campbell, titled "Joe Sack Tunes Queries in SQL Server!" was published on September 26, 2012 and runs 34 minutes.

September 26, 2012 ·34m · RunAs Radio

0:00 / 0:00

Summary

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!

Episode Description

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!

Share this episode

Similar Episodes

Radio War Nerd EP 597 — Pakistan in War & Peace, feat. Sabrina

Apr 9, 2026 ·101m

Radio War Nerd EMERGENCY EP 596 - Iran War Ceasefire

Apr 8, 2026 ·21m

Radio War Nerd EP 595 — Iran War Update: The Countdown

Apr 7, 2026 ·52m

Radio War Nerd EP 594 — Ukraine: The Forgotten War, feat. Peter Korotaev

Apr 3, 2026 ·93m

Radio War Nerd EP 593 — American Prestige Crossover

Mar 27, 2026 ·80m

Radio War Nerd EP 592 — Operation Barbarossa, pt. 8: Soviet Union in Wartime, feat. Annibale + Iran War update

Mar 25, 2026 ·109m

Similar Podcasts

War Nerd Radio — Subscriber Feed Gary Brecher Nothing fancy; just the wars, ma’am. It runs on your donations, like all guerrilla campaigns. Support the show! Ruínas de São Miguel Ana Lur No episódio explicamos um pouco sobre Patrimônio cultural material e imaterial do Brasil. Também escolhemos um patrimônio para ser fala (ruínas de São Miguel das missões) Harley Rucas/ Wolfman Harley Rucas Welcome to the Harley Rucas/ Wolfman podcast, where amazing things happen. The world and other stuff and sorry about my slurp This Well Runs Deep Monique Norington Joseph Black women are complex, we are unique, fragile, yet solid. Black women are the core of the family and the essence of humanity. This Well Runs Deep dives into the well of black womanhood exploring life, love, family, career, faith and everything in between.

URL copied to clipboard!