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/