SQL Server 2008, page compression and indexing
Page 1 of 1 • Share •
SQL Server 2008, page compression and indexing
Thought I'd share...
We are using SQL Server 2008. A staging table loaded with data from the source system had Page Compression turned on. We saw a 50% reduction in space with no significant reduction in performance. Added a clustered index and realized an additional 24% reduction in space. The index put like records together, enabling the page compression to be more efficient. And the index improved the performance.
We are using SQL Server 2008. A staging table loaded with data from the source system had Page Compression turned on. We saw a 50% reduction in space with no significant reduction in performance. Added a clustered index and realized an additional 24% reduction in space. The index put like records together, enabling the page compression to be more efficient. And the index improved the performance.
Jeff Smith- Posts: 311
Join date: 2009-02-03
Similar topics» Off-page optimization Tips
» Samsung all hardware solution in one page.. daily updated.. get..set.. go..
» new ryl2 server~~
» Nimbuzz Server
» Interview Questions with answers : Veritas Cluster Server
» Samsung all hardware solution in one page.. daily updated.. get..set.. go..
» new ryl2 server~~
» Nimbuzz Server
» Interview Questions with answers : Veritas Cluster Server
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum