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!

Episoder(287)

Episode 198: Cloud Infrastructure

Episode 198: Cloud Infrastructure

In a previous episode (175) we discussed migrating to the cloud, and we had a few comments from our compañeros which mentioned we should include more details around cloud infrastructure—the pieces or ...

23 Apr 202036min

Episode 197: Power Query in Power BI

Episode 197: Power Query in Power BI

In 1990, the group Snap! release a song called "The Power". It would take Microsoft more than 20 years, but they eventually came up with a series of 'power' tools they built into Excel. Those tools la...

15 Apr 202022min

Episode 196: Teleworking

Episode 196: Teleworking

This is a topic I have been interested in covering for some time and as our world faces a crisis dictating that we stay home, it seems like a good time to talk about teleworking. Everyone will have a ...

2 Apr 202035min

Episode 195: Understanding DAX

Episode 195: Understanding DAX

The number of new programming languages never ceases to amaze me. Technology advances continue to require new ways of allowing users to customize the way they use tools and Power BI is no different. I...

26 Mar 202039min

Episode 194: PolyBase Use Cases

Episode 194: PolyBase Use Cases

After Episode 180 on PolyBase came out, we received a few questions on use cases for PolyBase. Compañeros, when you ask, we reply! This episode we carve out 3 use cases for PolyBase and ways in which ...

19 Mar 202033min

Episode 193: Power BI Premium

Episode 193: Power BI Premium

Our regular host is down for the count with the flu; however, the podcast must go on! In this episode, we answer a listener-submitted question about Power BI Premium. Kevin and Eugene take us through ...

12 Mar 202029min

Episode 192: The DBA is Dead! Long Live the DBA!

Episode 192: The DBA is Dead! Long Live the DBA!

What is the future of the DBA and what technologies should I be focused on? In this episode, we attempt to look into the crystal ball and give our take on the future of work for the data platform prof...

4 Mar 202043min

Episode 191: Power BI Row-Level Security

Episode 191: Power BI Row-Level Security

Wouldn't it be nice if you could filter the rows a user sees in Power BI? What's that? You've already implemented Row-Level Security at the database level? Well, that actually won't help you in Power ...

12 Feb 202020min

Populært innen Fakta

fastlegen
dine-penger-pengeradet
relasjonspodden-med-dora-thorhallsdottir-kjersti-idem
mikkels-paskenotter
foreldreradet
rss-strid-de-norske-borgerkrigene
treningspodden
rss-bisarr-historie
jakt-og-fiskepodden
takk-og-lov-med-anine-kierulf
sinnsyn
rss-sunn-okonomi
hverdagspsyken
tomprat-med-gunnar-tjomlid
gravid-uke-for-uke
fryktlos
hagespiren-podcast
level-up-med-anniken-binz
rss-kull
rss-bak-luftfarten