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 71: BI Tools of the Trade

Episode 71: BI Tools of the Trade

It is easy to feel like the odd man (or gal) out in the SQL Community.  We are constantly hearing about new features, products, and architectures and our companies may not always have the same enthusi...

23 Nov 201638min

Episode 70 SQL Server on Linux

Episode 70 SQL Server on Linux

In the keynote of PASS summit 2016 Rohan Kumar, the program manager for SQL Server proudly displayed a database restore to a SQL Server instance installed on Linux. What makes this all even more inte...

16 Nov 201645min

Episode 69: Our SQL Server Setup Checklist

Episode 69: Our SQL Server Setup Checklist

We have all been there–next, next, next–let's just get this install done. While there are many ways to get SQL Server installed on a server, the real impact is in the way we administer the database a...

9 Nov 201638min

Episode 68: SSIS Administration

Episode 68: SSIS Administration

For all of us working with data, we know that we work no only with SQL Server but the suite of tools around the SQL Server engine.  In this episode, we share some thoughts around SSIS administration, ...

2 Nov 201652min

Episode 67 Dear Developer

Episode 67 Dear Developer

Compañeros! The good organizers SQLSaturday in Pittsburgh allowed me to take a slot on the schedule and opened up the podcast for a little Q&A session and I was super happy with the results. We had s...

27 Okt 201646min

Episode 66: Microsoft's Professional Program

Episode 66: Microsoft's Professional Program

After talking with Patrick Thomas in episode 64, I was introduced to Microsoft's newest learning curriculum, the Microsoft academy, and their first offering in data science.  In this episode, I talk w...

19 Okt 201631min

Episode 65: Do you have good data architecture?

Episode 65: Do you have good data architecture?

This week on the SQL Trail, Steve and I chat with Jason Horner about building a good data architecture. When talking about a data warehouse architecture, or even just a data architecture, people often...

12 Okt 201637min

Episode 64: Certifications and Career Development

Episode 64: Certifications and Career Development

Have you ever thought that Microsoft certifications were a waste of time? Depending on where you are on the experience scale, certifications still play a large role in hiring and career development. ...

5 Okt 201634min

Populärt inom Utbildning

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