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
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
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
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