Weekly Review: Auto Shrink for SQL Server is Evil

Paul Randall is a guy a I listen to in the SQL Server space. Eight and half years on the SQL Server team at Microsoft will do that.

In this review we look at Paul's post on Auto Shrink for SQL Server and why it's bad. It causes severe index fragmentation for starters and Paul has the scripts to prove it, so you can reproduce the problem yourself. Read the whole thing here.

Ok so, Auto Shrink for waistline, good. Auto Shrink for SQL Server, Bad. Got it. Now all I have to do is find that Auto Shrink for waistline app.