When you pass in a query, how does SQL Server build the results?
It sounds really simple, but we all take so much for granted.
SQL Server stores most data in 8KB pages – kinda like spreadsheet pages. For example, here’s a simulated 8KB page from the dbo.Users table in the Stack Overflow public database:
In a free live How to Think Like the SQL Server Engine webcast on April 7th, I’ll walk you through how SQL Server uses these spreadsheet pages to deliver your query results.
I will give you a scenario: I’m the end user sending in