How To Think Like The Sql Server Engine

You're comfortable writing queries to get the data you need. But you're uncomfortable if someone asks you how it works, how

You're comfortable writing queries to get the data you need. But you're UNcomfortable if someone asks you how it works, how ...

You're comfortable writing queries to get the data you need. But you're UNcomfortable if someone asks you how it works, how ...

You're a developer or a DBA comfortable writing queries to get the data you need. You're much less comfortable understanding ...

You've never had a formal class on Microsoft

You're a developer or a DBA, and you're comfortable writing queries to get the data you need. You're much less comfortable ...

Print out this 4-page PDF to follow along as I explain how

You're comfortable writing queries to get the data you need. But you're UNcomfortable if someone asks you how it works, how ...

You're comfortable writing queries to get the data you need. But you're UNcomfortable if someone asks you how it works, how ...

The query processor builds execution plans, and the storage

You're comfortable writing queries to get the data you need. But you're uncomfortable if someone asks you how it works, how

You're comfortable writing queries to get the data you need. But you're UNcomfortable if someone asks you how it works, how ...

Now that you're done with part 1, let's switch to SELECT *, add an ORDER BY, and see how

You've heard of my free

Why does one query get wildly different execution plans? Learn how statistics influence your query plans, discover how to see ...

Let's start with something simple – the Users table from Stack Overflow. You get just the clustered index of that table, and Brent ...

We finished part 2 by adding a nonclustered index. Now, let's see all the ways that makes our query go faster. Then, we'll add ...

We finished part 3 with two similar-looking queries that produce very different behavior: one does a seek, and the other does a ...

As we continue to learn how

One of the main sticking points for developers when they need to write