Russ Thomas – SQL Judo

The Art of SQL Server Database Administration, Development, and Career Skills for the Technically Minded

Violating AdventureWorks Dating Policy with Merge, Hash, and Loop Joins

The logical joins (inner, outer, left, right etc) are familiar to any SQL pro.  As the optimizer selects the physical join type that will actually perform the work however, this part of … Continue reading

October 13, 2014 · Leave a comment

HELP! PK is Running out of Identity Values

You never thought it’d happen.  Way back when you picked an Int as your PK with an auto-increment identity you said.  2.1 billion inserts??  That’ll never happen.  But business exploded.  Developers … Continue reading

September 16, 2014 · 2 Comments

Is Your SQL Server in Daylight Savings Time?

Remember the old ‘Deep Thoughts – by Jack Handy’ bit on Saturday Night Live.  One of those came across the cube wall today. “Hey – how can we figure out if the … Continue reading

May 1, 2014 · 2 Comments

When Is Alter Table Just a Meta Data Change

A typical question while reviewing code for release to production is whether an alter statement will change meta data only or cause page level activity.  I am not aware of a matrix or chart in … Continue reading

March 26, 2014 · 3 Comments

T-SQL Tue #51: Eye Heart You Dee Effs

I absolutely love this month’s TSql2sDay topic.  Take a generally accepted rule of being a DBA and argue against it.  If there is one thing I like more than being a DBA it … Continue reading

March 11, 2014 · 1 Comment