http://blogs.msdn.com/sqlserverstorageengine/archive/2008/12/20/enabling-compression-on-a-heap.aspxI often get a question how to do enable compression on a table that is a heap (i.e. it does not have a clustered index). Clearly, one could create the clustered index with compression option set to PAGE and then drop the clustered index. This is an expensiveenCommunityServer 2.1 SP1 (Build: 61025.2)http://blogs.msdn.com/sqlserverstorageengine/archive/2008/12/20/enabling-compression-on-a-heap.aspx#9245856Mon, 22 Dec 2008 00:19:18 GMT91d46819-8472-40ad-a661-2c78acb4018c:9245856SQL Server Storage Engine<p>In my previous blog <a rel="nofollow" target="_new" href="http://blogs.msdn.com/sqlserverstorageengine/archive/2008/12/20/enabling-compression-on-a-heap.aspx">http://blogs.msdn.com/sqlserverstorageengine/archive/2008/12/20/enabling-compression-on-a-heap.aspx</a></p>