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.…Continue readingStatistics and PowerBI Visualizations, Part Two
So this is my first T-SQL Tuesday post. This month’s challenge comes from Ewald Cress and is to recognize those who have made a meaningful contribution in your life in…Continue readingTSQL Tuesday #96
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…Continue readingFiltered Statistics
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…Continue readingBuffer Pool Extension
For any parents out there of multiple children, you are acutely aware of locking and blocking in the real world. Who gets to use the bathroom first? Hearing the phrase…Continue readingLocking and Blocking, Family Management.
Let’s explore common table expressions. Like we have shown with scalar-valued functions, the CTE may be useful, but can quickly hinder performance if not used responsibly. What is a CTE?…Continue readingOveruse of Common Table Expressions
You’ve read about Scalar-Valued functions and their RBAR(row by agonizing row) cost. You’ve also read about how combining recordsets can be costly. Now, we are going to discuss SARGability and…Continue readingTaking advantage of Sargability
After reading part 1 of the series, I hope that you have questioned the use of Scalar Valued Functions. Now, let’s pose some more questions. In this section, we are…Continue readingThe State of the Union