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
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
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
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
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
Russ Thomas - SQL Judo 