13 November 2007

Auto Shrink and SQL Index Fragmentation

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.

Today Paul dropped a 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.