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 NULL: Summer Break

Episode NULL: Summer Break

24 Jul 20191min

Episode 174: Power BI Report Server

Episode 174: Power BI Report Server

What do you do when you want to use the Visualizations of Power BI but management doesn't want to send company data to the cloud? Well, you can implement Power BI Report Server! In this episode we dis...

27 Jun 201931min

Episode 173: New Data Certifications

Episode 173: New Data Certifications

As the data platform continues to evolve, so do certifications. In this episode we chat with Rick Heiges about the new role-based certifications and how they fit into Microsoft's cloud platform. We re...

12 Jun 201936min

Episode 172: Power BI Monitoring

Episode 172: Power BI Monitoring

From a SQL Server perspective we have many ways to identify problem areas. In this episode, we discuss ways to diagnose performance issues in Power BI. They are certainly making many strides; however,...

5 Jun 201924min

Episode 171: SQL Server Encryption

Episode 171: SQL Server Encryption

You've got first name, last name, full name, birth date, address, email, phone, tax ID or Social Security Number, driver's license number, medical evaluation notes, MAC address, and IP address columns...

22 Mai 201933min

Episode 170: Devops with Power BI

Episode 170: Devops with Power BI

Two years ago blogger Jay Killeen observed, "And with modern languages and modern applications such as PowerBI and Power Query you should be safe to assume there would be modern tooling. You would be ...

15 Mai 201924min

Episode 169: Should you learn to code?

Episode 169: Should you learn to code?

These are dark times. Drastic measures must be taken. In this episode, we talk about--coding. *Queue scary music* Last year I bumped into Sean McCown and found out he had coded himself a GUI for his M...

8 Mai 201943min

Episode 168: Data Privacy Settings

Episode 168: Data Privacy Settings

One of the great abilities we have with Power BI is connecting to multiple data sources. Authors can actually publish data sources for others to use in their reports. Developers then get to mix and ma...

1 Mai 201919min

Populært innen Fakta

fastlegen
dine-penger-pengeradet
relasjonspodden-med-dora-thorhallsdottir-kjersti-idem
mikkels-paskenotter
foreldreradet
rss-bisarr-historie
treningspodden
rss-strid-de-norske-borgerkrigene
jakt-og-fiskepodden
rss-sunn-okonomi
ukast
hverdagspsyken
lederskap-nhhs-podkast-om-ledelse
sinnsyn
rss-bak-luftfarten
takk-og-lov-med-anine-kierulf
fryktlos
rss-kunsten-a-leve
rss-kull
gravid-uke-for-uke