We each have our way of going about things–this is what makes us unique. When it comes to getting data out of the database, many times we might think that SQL Server would go about getting data the same way we would. If you think about scanning a Microsoft Excel document, how would you find the record you are looking for? How does that differ from SQL Server?
My guest for this episode is Brent Ozar and we chat about internals and how SQL Server processes your request and what you need to consider as SQL Server returns your result.
Our show notes for today's episode are available at http://sqldatapartners.com/2016/02/03/sqlserverthinks/
Episode 40: SQL Server Compression
Episode 39: Set statistics and StatisticsParser.com
Episode 38: SQL Server 2016 Feature Review
Episode 37: PowerBI and the DBA
Episode 36: SQL Server Virtual Machines in Azure
Episode 35: Position Yourself to Better Opportunities
Episode 34: In-Memory Tables
Episode 33: From Developer To DBA
Episode 32: Up Your Game With PowerShell!
Episode 31: What Has Virtualization Done To My Database?
Episode 30: The Best Investment You Can Make
Episode 28: How Do You Know There Is A Problem? Baselines!
Episode 27: Testing Changes Before You Break Production
Episode 26: DevOps for the Database--Everyone is Doing it, Right?
Episode 25: Stretch Database
Episode 24 Query Store
Episode 23: IO, IO, It’s Off to Tune We Go
Episode 22: Eight Years of sp_whoisactive
Episode 21: Azure Data Factory
Create your
podcast in
minutes
It is Free
Insight Story: Tech Trends Unpacked
Zero-Shot
Fast Forward by Tomorrow Unlocked: Tech past, tech future
Lex Fridman Podcast
All-In with Chamath, Jason, Sacks & Friedberg