When To Use Auto Shrink
Never, that’s when. Don’t want to believe me? Well then, who would you believe? How about the SQL Craftsman, a man with more MVP-ness than myself. What’s that? Not good enough for you? Well, then, let me introduce you to Paul Randal. He had some thoughts on the subject. http://blogs.msdn.com/sqlserverstorageengine/archive/2007/03/28/turn-auto-shrink-off.aspx http://www.sqlskills.com/blogs/paul/post/Auto-shrink-e28093-turn-it-OFF!.aspx So why is this … Read more