April 7, 2014 at 3:41 am
What is the difference between DBCC Shrinkdatabase and Compressing a table (or any other object) using row or page compression?
Currently i am working on ways to save disk space .I came across these two,but am not able to figure out the difference between the two.
April 7, 2014 at 3:57 am
DBCC SHRINKDATABASE will Shrinks the size of the data and log files in the specified database. Free unallocated space in the database.
PAGE COMPRESSION will result into Data compression. You can use the data compression feature to help compress the data inside a database, and to help reduce the size of the database.
HTH
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 7, 2014 at 6:27 am
Shrinking the file or the database is reclaiming space that was allocated in the database, but is not currently in use. Compression is taking a value and making it smaller through a compression algorithm so that it takes up less space when stored. These are two radically different ideas. One is for management of the database files. The other is for management of the data itself.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply