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