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 136: Devops with Visual Studio
Episode 135: Seinfeld Episode
Episode 134: CosmosDB
Episode 133: Shrinking Files
Episode 132: What technologists can learn from superheroes
Episode 131: Big Data Solutions in the Cloud
Episode 130: Use Case for PowerShell
Episode 129: Graph Databases
Episode 128: Database Doing DevOps
Episode 127: Developing in the database
Episode 126: SQLSaturday Edition
Episode 125: You must be an engineer
Episode 124: Beyond the runbook; DR Organization
Episode 123: Top 5 things to know when getting admin access
Episode 122: Isolation Levels
Episode 121: What makes a good manager?
Episode 120: SQL Injection
Episode 119: Getting started with GitHub
Episode 118: How has index maintenance changed?
Episode 117: PASS Summit Retrospective
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