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.

Previous Post
Updated First Responder Kit and Consultant Toolkit for August 2020
Next Post
sp_BlitzIndex Pro Tips for Consultants & Contractors

5 Comments. Leave new

Leave a Reply

Your email address will not be published. Required fields are marked *

Fill out this field
Fill out this field
Please enter a valid email address.

Menu
{"cart_token":"","hash":"","cart_data":""}