Explaining SQL Server Statistics with Playing Cards


When you run a query, how does SQL Server estimate the number of rows? I’ll explain in this half-hour video demo using playing cards, then showing the same issues in SQL Server Management Studio:

Here’s the demo script I use in the video.

To learn more, check out our free statistics class on YouTube.

This week’s sponsor: Have database performance questions? Gain real-world insight into successfully planning, building and operating a modern database environment.