Episode 81 Indexes Part 1

Episode 81 Indexes Part 1

Part of what we like to do on podcast is to present topics and discuss different ways you might use features. In this episode, we go back to basics and discuss indexes. Like most topics, we made sure to explain all the important aspects. Because this is a such broad topic, we decided to carry this over into our next episode as well. Using the phone book as an example, we chat with our guest Randolph West and explain heaps, non-clustered indexes, and clustered indexes. We also explain best practices to use them when creating new tables.

We didn't forget to cover the problems you might run into. For example, you might not think about indexes until your data grows very large. Sure, you can attempt to resolve the problem by moving to SSD's and increasing memory, but this will push the issue further in the future. In this episode, we will discuss considerations for indexes and why database architecture is so important.

We would like to hear your opinions. What are your strategies when using indexes? Use the hashtag #sqlpodcast and let us know!

The shownotes for today's episode is found at http://sqldatapartners.com/2017/02/01/episode-81/ and have fun on the SQL trail.

Episoder(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 Mar 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 Mar 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 Mar 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 Mar 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 Mar 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 innen Fakta

fastlegen
mikkels-paskenotter
dine-penger-pengeradet
relasjonspodden-med-dora-thorhallsdottir-kjersti-idem
foreldreradet
treningspodden
rss-strid-de-norske-borgerkrigene
jakt-og-fiskepodden
takk-og-lov-med-anine-kierulf
sinnsyn
hverdagspsyken
rss-bisarr-historie
gravid-uke-for-uke
rss-kunsten-a-leve
tomprat-med-gunnar-tjomlid
rss-sunn-okonomi
rss-kull
hagespiren-podcast
fryktlos
rss-var-forste-kaffe