SQLWareWolf.com

For the SQL Lycan in us all

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

Share

SQL Saturday #521 Atlanta

I am honored to be accepted to speak and return Atlanta, GA on Saturday, May 21, 2016.  Along with seeing great #sqlfamily and being able to share what I can from a hopefully unique perspective. Atlanta will have a plethora of great minds to learn from. This is possibly the biggest SQL Saturday on the […]

Share

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

Share

SQL Saturday #461 Austin

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 what I can from a hopefully unique perspective, I’m excited to see Austin as a hub of technology! I will be discussing Service Broker from […]

Share

SQL Saturday #480 Nashville

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 what I can from a hopefully unique perspective, I’m excited to see Nashville as a country music fan. I will be discussing Locks, Blocks and […]

Share

Deadlocking – Deciding which child gives up what they want

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 were having burgers for dinner.  My youngest was sitting at the table with the ketchup and my eldest had both hers and her sister’s burger. […]

Share

Locking and Blocking, Family Management.

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 “I saw that first”.  I want that.  Fighting over a toy.  Each parent has their own methods of how to resolve these disputes. Just as […]

Share

Overuse of Common Table Expressions

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? Microsoft’s definition of a CTE: Specifies a temporary named result set, known as a common table expression (CTE). This is derived from a simple query and […]

Share

Taking advantage of Sargability

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 how avoid statements that take the fun out of the seek. Searching! Seek and Destroy! Ok, so we’re not going to seek and destroy, but […]

Share

The State of the Union

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 going to review the Union operator benefits and costs. The Distinct State of the Union As microsoft puts it, a Union combines the results of […]

Share
SQLWareWolf.com © 2016 Frontier Theme