Printed 2017/08/20 07:27PM

Article of the Week – Sanjay Mirsha (Data Compression)

By Patrick LeBlanc, 2009/11/10

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 and

Copyright © 2002-2017 Redgate. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.