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.
Episode 236: Database Monitoring with SQL Sentry
Episode 235: SQL Trail 2021 In-person Q&A
Episode 234: Communication Tips for the IT Pro
Episode 233: ScriptDOM
Episode 232: Giving Technical Presentations
Episode 231: Mental Health and Wellness in IT
Episode 230: RTO & RPO
Episode 229: Data Migration Assistant
Episode 228: Predicting Application Problems with Database Metrics
Episode 227: SSDT Methodologies for DB DevOps
Episode 226: SQL Server IaaS Agent Extension
Episode 225: Dashboard Design Principles
Episode 224: The Standup Meeting
Episode 223: Podcast Update
Episode 222: Azure Arc-enabled Data Services
Episode 221: SQL Trail March 2021 Retrospective
Episode 220: Microsoft Ignite Recap
Episode 219: SQL Server Inventory
Episode 218: File Growths
Episode 217: A Little Something About A Few Things
Create your
podcast in
minutes
It is Free
Insight Story: Tech Trends Unpacked
Zero-Shot
Fast Forward by Tomorrow Unlocked: Tech past, tech future
The Unbelivable Truth - Series 1 - 26 including specials and pilot
Lex Fridman Podcast