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 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
Episode 116: Are people still using PSSDiag?
Episode 115: The Companero Conference Retrospective
Episode 114: How do you start consulting?
Episode 113: Standing on the shoulders of giants
Episode 112: Keeping up with patching
Episode 111: How do you prepare for conferences?
Episode 110 How do I build trust with my team
Episode 109: To certify or not to certify?
Episode 108: The Future of the Relational Database
Episode 107 BI for the Little Guy
Episode 106 Temporal Tables
Episode 105 When is enough, enough?
Episode 104: Keeping up with technology
Episode 103 Plan Reuse
Episode 102 Monitoring Availability Groups
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
Elliot in the Morning