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

START TIME: 10:00am Pacific Time / 1:00pm Eastern Time (what time for you?)
LENGTH: 75 minute session + 15 minute Q&A

 

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/

Join ONLY for Session 8

If you’ve already signed up for ALL SQLskills Insider Sessions, you’ll receive information about how to join each session and a 2 hour reminder.  

If you’d prefer to sign up for only individual sessions, you can sign up for Session 8: Understanding Statistics here:

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

[]