SQLWareWolf.com

SQL Saturday #461 Austin

January 28, 2016March 16, 2016william.j.wolf

I am honored to be accepted to speak in Austin, TX for the first time on Saturday, January 30, 2016. Along with seeing great #sqlfamily and being able to share…Continue readingSQL Saturday #461 Austin

SQL Saturday

SQL Saturday #480 Nashville

January 11, 2016January 11, 2016william.j.wolf

I am honored to be accepted to speak in Nashville, TN for the first time on Saturday, January 16, 2016. Along with seeing great #sqlfamily and being able to share…Continue readingSQL Saturday #480 Nashville

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

Common Coding Mistakes

Scalar Value and Built-In Functions

February 8, 2014January 29, 2021william.j.wolf

Throughout my career, it has become my strong opinion that the majority of performance problems are self-inflicted due to database design or coding that is less than optimal. This series…Continue readingScalar Value and Built-In Functions