Epsidode 49: Temp Tables VS Table Variables

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

Recorded22 Jun 2016

Publisherfeeds.libsyn.com ↗

Handlerec:13688314

Show notes

When you code and you need to use a temporary object what do you use in SQL Server--temp tables or a table variable? There is plenty of conventional wisdom out there and my guest Wayne Sheffield and I talk about the differences between these two objects. Whether it around performance or coding standards, it seems everyone has an opinion about these objects. Check out the show notes for today's episode at http://sqldatapartners.com/2016/06/21/sql-server-temp-tables/ and I will see you on the SQL Trail compañeros!

Ask this episode

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

Sign in