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.

Jaksot(287)

Episode 07: SQL Server Security

Episode 07: SQL Server Security

I chat with Microsoft MVP Chris Bell about database security and some seemingly cavelier attitudes some organziations have about keeping data safe.  We hit some of the methods SQL Server has to protec...

2 Syys 201541min

SQL Data Partners Podcast: Episode 06 Build Your Personal Brand

SQL Data Partners Podcast: Episode 06 Build Your Personal Brand

Steve Jones, the editor from SQL Server central and I talk about the need to build your own brand and we share a few ideas on how to do that.  We talk about Steve's brand and how he built that over ti...

26 Elo 201532min

SQL Data Partners Episode 05: Principal of Least Privilege

SQL Data Partners Episode 05: Principal of Least Privilege

Robert Verell and I chat about good security practices and the principle of least privilege.  We discuss Robert's rule to never give anyone db_owner, other groups and Robert's home grown group to give...

19 Elo 201531min

SQL Data Partners Podcast Episode 04: Advanced Backup Options

SQL Data Partners Podcast Episode 04: Advanced Backup Options

We finish up our conversation with MVP Tim Radney on backup options with discussions on encryption and Azure.  Tim also shares his favorite tools and his super hero power of choice. Erik Véliz, the cr...

12 Elo 201519min

SQL Data Partners Podcast Episode 03: Backup and Recovery

SQL Data Partners Podcast Episode 03: Backup and Recovery

I chat with MVP Tim Radney about Backup and Recovery options in SQL Server. We chatted for quite awhile and I ended up making two episodes out of our conversation. This episode focuses on why we bac...

5 Elo 201531min

SQL Data Partners Podcast Episode 02: Extended Events

SQL Data Partners Podcast Episode 02: Extended Events

I was in Argentina for the SQLSaturday event in May of 2015 and made friends with Javier Villegas, a 20 year veteran in the DBA world. While extended events have been around for some time, many are s...

5 Elo 201524min

SQL Data Partners Podcast Episode 00: Who I Am and What the Podcast is About

SQL Data Partners Podcast Episode 00: Who I Am and What the Podcast is About

Today I am super happy to announce the launch of my podcast and I start with episode 00. In this episode I take some time to go through my journey in becoming a data professional and how I think the p...

5 Elo 201524min

Suosittua kategoriassa Koulutus

rss-murhan-anatomia
rss-narsisti
voi-hyvin-meditaatiot-2
psykopodiaa-podcast
adhd-podi
rss-niinku-asia-on
rss-valo-minussa-2
rss-rahamania
rss-vapaudu-voimaasi
mielipaivakirja
aamukahvilla
rahapuhetta
kesken
psykologia
rss-koira-haudattuna
ilona-rauhala
nakokulmia-rikollisuudesta-irrottautumiseen
rss-keskeneraiset-aidit
rss-tietoinen-yhteys-podcast-2
rss-arkea-ja-aurinkoa-podcast-espanjasta