SQL Tact

What's a "soft delete", and why should DBAs be aware of such behavior in tables? So, a DELETE statement is a “hard” delete...

Wrote this email exchange with some developer colleagues about to embark on performance tuning. Subject:  bag o' tricks from DMV talk ...

One feature that many of my clients are unaware of is that the  batched execution of a stored procedure can be replicated under certain circ...

Wrote this email recently to a crew of developers who were shooting themselves in the foot with a database rich in varchar(max) data types. ...

The SQL Server Management Studio built-in standard report for "Disk Usage" is very handy to view the performance-sucking autogrowt...

This one's a gimme, but an underrated utility script when I enter a new environment and look for low-hanging fruit for easy improvements...

Thanks to the 15+ folks who attended the Baton Rouge SQL Server User Group meeting last night!  I hope everyone enjoyed "everyone gets ...

Here's a redacted version of a Q&A I had with one of the devs (who is not a DBA) at my consulting company. I thought it was worth s...

UPDATED 5/30/2019, the latest version of this script is in the Toolbox here:  https://github.com/SparkhoundSQL/sql-server-toolbox/blob/maste...

Update: There's a saying that when you look at your old code, you should feel you want to improve it? This is one of those. WDA 20180927...