SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Article of the Week – Sanjay Mirsha (Data Compression)

Data Compression was introduced in SQL Server 2008.  This feature helps compress data inside the database, thus potentially reducing the size of the database.  In the article titled, Data Compression:  Strategy, Capacity, Planning and Best Practices, the author outlines several pertinent details regarding the implementation of this new feature.  Some topics discussed included:  What to Compress, Estimating Space Savings, Resource Requirements and the Side Effects of Compressing a Table or Index.  The article also includes a couple of scripts that will help you determine what level of compression should be used. 

To read the article in its entirety click here.

Talk to you soon

Patrick LeBlanc, Founder www.tsqlscripts.com and www.sqllunch.com


Posted by Soorya on 15 January 2012

After using row/page/index compression in SQL 2008 DB, I noticed that DB size is increased. Before compression the DB size was 69 GB. After row compression on all tables, size increased to 73GB. Please explain.

Leave a Comment

Please register or log in to leave a comment.