THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Lara Rubbelke

Interesting Things in the World of SQL Server

Should I Compress My Indexes? New Compression Whitepaper!

A very well written study of the compression is now available: Data Compression - Strategy, Capacity Planning and Best Practices.  This study provides guidance on best practices for designing, implementing and managing compression in your environment.  I found this whitepaper to be full of useful guidance and scripts to monitor and manage compressed tables. 

The paper starts with tips and tools to help decide what to compress.  It then guides the reader through considerations for implementing compression and estimating necessary resources to complete compression.  The final sections of the paper provide guidance and evidence on management topics – space management, performance management, partition management. 

I am certain that those who are considering compression will find these concepts, scripts and tools to support the full lifecycle of compression.  I know that I will keep this on my short list of favorite whitepapers!

Published Sunday, May 31, 2009 11:27 AM by Lara Rubbelke


No Comments
New Comments to this post are disabled
Privacy Statement