Episode 142: Do You Have a HEAP of Hurting?

episode

SQL Data Partners Podcast 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

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

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

Report any issue

Source

Recorded26 Jul 2018

Publisherfeeds.libsyn.com ↗

Handlerec:13688221

Show notes

Are you giving yourself a HEAP of trouble by using tables with no clustered indexes? But it is faster you say . . . because you don't have to worry about the sorting when inserting. Our guest Rick Lowe suggests everything is fast until you decide to SELECT, UPDATE, or DELETE. We talk about why you may or may not want to use HEAP tables. I know I was surprised to get his take on the use of HEAP tables and I think you will be, too. Do you agree with our assessment? Let us know in the comments on the show notes page. The show notes for today's episode can be found at http://sqldatapartners.com/2018/07/25/episode-142-do-you-have-a-heap-of-hurting. Have fun on the SQL Trail!

Ask this episode

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

Sign in