1

Using Data Compression, my table size was reduced from 1770 MB to 250 MB, but the database size was not reduced. Why?

1

You can also shrink a database and shrink database files. See MS:

http://msdn.microsoft.com/en-us/library/ms189035(v=sql.105).aspx

Erik

  • 2
    You should beware when shrinking database files, it affects performance negatively - see sqlskills.com/blogs/paul/… – user5094 May 18 '13 at 12:04

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy