SQLskills Insider Session 8: Understanding Statistics - the Histogram

One of the most important aspects to estimation and optimization is the histogram component of statistics. In this demo-heavy session, we’ll look at multiple histograms and discuss the information stored and how SQL Server uses it for optimization. We’ll also talk about some of the reasons for why SQL Server limits the histogram to 200 (well, really 201) steps and how you can get around it (for some specific use cases).

SQLskills Insider Session #8: VIDEO

Return to our past sessions page here.

Session #8: Resources

Wow! I intentionally created only 3 slides so that we could “free style” off of my demos and your questions and WOW was that fun. Thank you! I do love great statistics discussions. And, as a result of running for the full 2 hours – we’re going to come back next week and keep discussing the histogram!

Resources for this SQLskills Insider Session: download

See our upcoming Insider Sessions here.

NOTE: If you want to attend ALL Insider Sessions, return to the main page and register your email there!

 

Presented by
Kimberly L. Tripp
President and Founder, SQLskills

Read my full bio here: Kimberly L. Tripp and about my Celebrating 25 Years of SQLskills here: https://www.sqlskills.com/about/meet-the-team/celebrating25years/