Russ Thomas – SQL Judo

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

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

The Single Greatest Feature of Microsoft SQL Server

SQL 2014 RTM was just announced! I started working with SQL Server at version 7.0.  It was upgraded to 2000 a few months later so I don’t have tons of experience with 7.0 but … Continue reading

March 15, 2014 · 1 Comment

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

Cardinality of dm_exec_sessions and dm_exec_connections

For my own edification I have been working on a simplified entity relationship map of some of the more popular DMVs.  Yes I know Microsoft already makes this available.  But working it … Continue reading

March 7, 2014 · 1 Comment