June 5, 2013 by Mike Hillwig
I was looking at syntax of DBCC SHRINKDATBASE today and came across a little gem. Yes, I’m shrinking. I’m also doing it to recover close to a terabyte of storage. But I’m staying in control of when we shrink.
Looking at the MSDN page with the syntax, I came across this little nugget of truth.
Let me copy and paste the text so that the search engines pick this up, too.
Unless you have a specific requirement, do not set the AUTO_SHRINK database option to ON.
Countless people have documented this before, myself included. Microsoft is saying it. Please disable AUTO_SHRINK. Now. Please.
And then after you disable AUTO_SHRINK, please look at your indexes. They’re probably a mess.