2013-06-28

TSQL - Effect of database shrinking

Take a look at the effects of shrinking a random database in SQL server. This may not be completely conclusive, but perhaps a good example. In sum:

  • Index space unaffected
  • Data used space unaffected
  • The log practically disappears


Below are before and after screenshots.

Before:

After:

By

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)