Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Nicholas Cain SQL Server 2008 and Data Compression RE: SQL Server 2008 and Data Compression
Steve Jones - SSC Editor
SSC Guru
Points: 734434
More actions
January 7, 2009 at 8:18 am
#922574
It doesn't make sense to move fact tables out. As mentioned above, compression works at the table level, and also at the index level. You can compress a table and not the indexes, or vice versa, or compress both.