Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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

share|improve this question

migrated from stackoverflow.com May 19 '13 at 21:14

This question came from our site for professional and enthusiast programmers.

up vote 1 down vote accepted

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

share|improve this answer
2  
You should beware when shrinking database files, it affects performance negatively - see sqlskills.com/blogs/paul/… – user5094 May 18 '13 at 12:04
    
Thanks Erik, it work :) – Hadi Delphi May 18 '13 at 12:08

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.