For the SQL Lycan in us all

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[…]

Filtered Statistics

Filtered Statistics For me, tuning the Microsoft Data Platform and SQL Server is a simple principle, make the engine do as little work as possible. For the engine and the optimizer to be able to do so, we need to feed it the appropriate information. The SQL Server Cardinality Estimator(CE) does it’s best to analyze Read more about Filtered Statistics[…]

Buffer Pool Extension

Working with Buffer Pool Extension There are many limitations to the SQL Server Standard Edition Database Engine.  In my opinion, one of the most confining is the memory limitation.  Many of us know the Page Life Expectancy counter, but why is this important?  For SQL Server to deliver data to you, the data is read Read more about Buffer Pool Extension[…]

SQL Saturday #517 Philadelphia

I am honored to be accepted to speak and return Philadelphia, PA on Saturday, June 04, 2016.  Along with seeing great #sqlfamily and being able to share what I can from a hopefully unique perspective. I will be discussing Common T-SQL Coding mistakes and referencing SARGability and RBAR. As database code tuners, we may get Read more about SQL Saturday #517 Philadelphia[…]

SQL Saturday #486 Richmond

I am honored to be accepted to speak and return Richmond, VA on Saturday, March 19, 2016.  Along with seeing great #sqlfamily and being able to share what I can from a hopefully unique perspective. I will be discussing Service Broker from the perspective of coaching/playing football.  Let’s see how we can relate Service Broker Read more about SQL Saturday #486 Richmond[…]