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.

Avsnitt(287)

Episode 223: Podcast Update

Episode 223: Podcast Update

With both Kevin and Eugene busy this week, Carlos went solo to share a few changes to the podcast, including the Twitch livestream moving to Tuesday, how you can support the podcast, and podcast episo...

14 Apr 20219min

Episode 222: Azure Arc-enabled Data Services

Episode 222: Azure Arc-enabled Data Services

Azure Arc-enabled data services provide powerful capabilities to deploy and manage local, on-premises, and hybrid cloud data resources using the same centralized management and tooling you get from th...

24 Mars 20211h 4min

Episode 221: SQL Trail March 2021 Retrospective

Episode 221: SQL Trail March 2021 Retrospective

Virtual conferences are just not the same as the conferences we are used to, but we're still determined to provide a good learning and networking environment for our friends. We very much miss having...

22 Mars 202139min

Episode 220: Microsoft Ignite Recap

Episode 220: Microsoft Ignite Recap

As we prepare for SQL Trail on March 18th, we peek back at Microsoft Ignite and review the announcements made there—filtering out the pieces our compañeros will enjoy hearing about. Did we miss someth...

10 Mars 202145min

Episode 219: SQL Server Inventory

Episode 219: SQL Server Inventory

How do you document your SQL Server environments? I can remember walking through Brent Ozar's takeover script back in the day and how cumbersome it was to put all that information together. We have a ...

24 Feb 202147min

Episode 218: File Growths

Episode 218: File Growths

In this episode of the SQL Data Partners Podcast, Eugene and I go back to our DBA beginnings and talk about database file growth, how to manage files and how to tell when a file has grown. The show no...

17 Feb 202130min

Episode 217: A Little Something About A Few Things

Episode 217: A Little Something About A Few Things

The story begins with a process that has been running forever and suddenly decides to cause grief by filling up tempdb. We talk about patching, and we talk about mental health. We talk a little about ...

10 Feb 202134min

Episode 216: EDI vs ETL

Episode 216: EDI vs ETL

When working on a customer on an import process, she made the comment—if we were doing true EDI, we'd [Do X]. The comment got me thinking—Aren't we working on an EDI process? As someone who frequentl...

3 Feb 202132min

Populärt inom Utbildning

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