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).
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!
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/