Statistics and PowerBI Visualizations, Part Two

January 7, 2018March 15, 2021william.j.wolf

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

Optimization and Tuning

Statistics and PowerBI Visualizations, Part One

November 24, 2017December 17, 2017william.j.wolf

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…Continue readingStatistics and PowerBI Visualizations, Part One

Uncategorized

TSQL Tuesday #96

November 14, 2017November 14, 2017william.j.wolf

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

Blue Collar SQL, General Administration

Filtered Statistics

August 8, 2017November 14, 2017william.j.wolf

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

Blue Collar SQL, General Administration

Buffer Pool Extension

June 18, 2017January 30, 2021william.j.wolf

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

General Administration

Deadlocking – Deciding which child gives up what they want

January 26, 2015November 28, 2017william.j.wolf

As we have spoken about before, parents of siblings or the siblings themselves understand what it is like for a parent to have to resolve a squabble. Recently, my daughters…Continue readingDeadlocking – Deciding which child gives up what they want

General Administration

Locking and Blocking, Family Management.

January 20, 2015January 28, 2016william.j.wolf

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.

Common Coding Mistakes

Overuse of Common Table Expressions

October 1, 2014January 28, 2016william.j.wolf

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

Common Coding Mistakes

Taking advantage of Sargability

March 6, 2014October 6, 2014william.j.wolf

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

Common Coding Mistakes

The State of the Union

February 16, 2014October 2, 2014william.j.wolf

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