Statistics and PowerBI Visualizations, Part Two

In the previous post, we went over the details of DBCC_SHOW_STATISTICS, now let’s see how this comes together.  We shall run the histogram for the ProductID from the Sales.SalesOrderDetail table.  

Pay attention to the Range_HI_Key of 831.   The Avg_Range_Rows are 36 2/3.   Now let’s run a query to see how SQL Server Read more about Statistics and PowerBI Visualizations, Part Two[…]

Statistics and PowerBI Visualizations, Part One

Statistics and PowerBI Visualizations, Part One In an effort to teach myself PowerBI, I thought that I could learn PowerBI while working with something that I know.  While in New York City, I was discussing this topic with the incomparable Patrick LeBlanc(b|t).  In the end, we decided that we would do a session together where Read more about Statistics and PowerBI Visualizations, Part One[…]