Russ Thomas – SQL Judo

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

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

Featured · Leave a comment

TSQL Tue #58: Passwords and Registered Servers

It’s TSQL Tuesday!!!  The topic was picked by Sebastian Meine over at SQLIty.net who is hosting this month’s edition of the rotating monthly blog party known as TSQL Tuesday.  Sebastian … Continue reading

September 9, 2014 · 2 Comments

31 Days of SQL Server Management Studio

I have always wanted to do a 31 day series.  Something like Kehayias’ 31 days of extended events, or Strate’s 31 days of SSIS.  These posts in turn were inspired by … Continue reading

August 1, 2014 · Leave a comment

T-Sql Tue #56: Aint Nutin’ My Problem

You know what happens when you assume right?  Of course you do.  That little play on words is pretty well played out.  In fact, if at least one other blog … Continue reading

July 8, 2014 · 3 Comments

Confessions of a Brand Snob

I’m actually pretty used to finding things out about myself that I would rather not know.  I can’t bench 400 lbs.  I haven’t run a sub 6 minute mile in 20 … Continue reading

June 4, 2014 · 1 Comment

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
Follow

Get every new post delivered to your Inbox.