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.
You, Me and Dynamics GP
The premier information site for Microsoft Dynamics GP
Showing posts with label Auto Shrink. Show all posts
Showing posts with label Auto Shrink. Show all posts
29 July 2010
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.
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.
Subscribe to:
Posts (Atom)