Episode 142: Do You Have a HEAP of Hurting?

Episode 142: Do You Have a HEAP of Hurting?

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!

Avsnitt(287)

Episode 39: Set statistics and StatisticsParser.com

Episode 39: Set statistics and StatisticsParser.com

Today on the SQL Trail I talk with Richie Rump, the podcaster, blogger, and now new hire at Brent Ozar. He and I discuss measuring query performance, using SET STATISTICS, and the story behind his Sta...

13 Apr 201630min

Episode 38: SQL Server 2016 Feature Review

Episode 38: SQL Server 2016 Feature Review

Compañeros! You heard rumblings about how awesome SQL Server 2016 is, right?  I talk with Rick Heiges about the wins he's seen for his clients using SQL Server 2016, including how one client's move fr...

6 Apr 201628min

Episode 37: PowerBI and the DBA

Episode 37: PowerBI and the DBA

In this episode of the SQL Data Partners podcast I sit with Patrick LeBlanc during SQL Saturday RVA. We chat about Microsoft PowerBI. PowerBI is a business intelligence tool that easily connects dispa...

30 Mars 201627min

Episode 36: SQL Server Virtual Machines in Azure

Episode 36: SQL Server Virtual Machines in Azure

You can host SQL Server on Azure Virtual Machines in a variety of configurations, ranging from a single database server to a multi-machine configuration.  In this episode of the SQL Data Partners Podc...

23 Mars 201631min

Episode 35: Position Yourself to Better Opportunities

Episode 35: Position Yourself to Better Opportunities

On Episode 35 of The SQL Data Partners Podcast, I talk with Philip Morgan of The Positioning Manual for Technical Firms. Philip’s book has influenced my work at SQL Data Partners, so I wanted to bring...

16 Mars 201634min

Episode 34: In-Memory Tables

Episode 34: In-Memory Tables

Hello, compañeros! You’ve heard of Hekaton and in-memory tables before, but what does in memory really mean for your database? Perhaps you have questions like I did, like how does in memory OLTP diffe...

9 Mars 201643min

Episode 33: From Developer To DBA

Episode 33: From Developer To DBA

Many developers will make the transition to the DBA role and in this episode I chat with Amy Herold about making that very move.  Amy started as a C#/.NET developer and moved into the database world a...

2 Mars 201629min

Episode 32: Up Your Game With PowerShell!

Episode 32: Up Your Game With PowerShell!

PowerShell, isn't that a Windows Administration tool?  This is certainly how it is positioned by Microsoft, but why should the DBA community give it more than a passing glance?  My guest is Mike Fal a...

24 Feb 201631min

Populärt inom Utbildning

historiepodden-se
rss-bara-en-till-om-missbruk-medberoende-2
det-skaver
alska-oss
harrisons-dramatiska-historia
nu-blir-det-historia
not-fanny-anymore
roda-vita-rosen
johannes-hansen-podcast
rss-foraldramotet-bring-lagercrantz
rss-viktmedicinpodden
i-vantan-pa-katastrofen
sa-in-i-sjalen
sektledare
rss-max-tant-med-max-villman
allt-du-velat-veta
rikatillsammans-om-privatekonomi-rikedom-i-livet
rib-podcast
rss-sjalsligt-avkladd
rss-basta-livet