http://sqlblog.com/blogs/lara_rubbelke/archive/tags/Compression/default.aspxTags: CompressionenCommunityServer 2.1 SP2 (Build: 61129.1)http://sqlblog.com/blogs/lara_rubbelke/archive/2009/05/31/should-i-compress-my-indexes-new-compression-whitepaper.aspxSun, 31 May 2009 15:27:00 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:14357Lara Rubbelke0http://sqlblog.com/blogs/lara_rubbelke/comments/14357.aspxhttp://sqlblog.com/blogs/lara_rubbelke/commentrss.aspx?PostID=14357http://sqlblog.com/blogs/lara_rubbelke/rsscomments.aspx?PostID=14357<P align=left>A very well written study of the compression is now available: <A title="Data Compression- Strategy, Capacity Planning and Best Practices" href="http://msdn.microsoft.com/en-us/library/dd894051.aspx" target=_blank>Data Compression - Strategy, Capacity Planning and Best Practices</A>.&nbsp; This study provides guidance on best practices for designing, implementing and managing compression in your environment.&nbsp; I found this whitepaper to be full of useful guidance and scripts to monitor and manage compressed tables.&nbsp; </P> <P align=left>The paper starts with tips and tools to help decide what to compress.&nbsp; It then guides the reader through considerations for implementing compression and estimating necessary resources to complete compression.&nbsp; The final sections of the paper provide guidance and evidence on management topics – space management, performance management, partition management.&nbsp; </P> <P align=left>I am certain that those who are considering compression will find these concepts, scripts and tools to support the full lifecycle of compression.&nbsp; I know that I will keep this on my short list of favorite whitepapers!</P><img src="http://sqlblog.com/aggbug.aspx?PostID=14357" width="1" height="1">CompressionMaintenanceSQL Server 2008