Free Video Training: Estimation and Statistics by Dave Ballantyne

It’s hard to find good 400-500 level SQL Server training at any price, let alone free. Dave Ballantyne’s past sessions from SQLBits are great examples of those.

Today, I’m going to review Dave’s most recent session on Estimation and Statistics. It’s from 2015, but it’s still very relevant today.

If you want to jump past the intro and bio, the technical stuff starts at about 2 minutes 15 seconds in.

Dave starts by explaining how building a query plan is a lot like building a driving route from point A to point B. I love that analogy because: