SQL Server 2008, page compression and indexing

View previous topic View next topic Go down

SQL Server 2008, page compression and indexing

Post  Jeff Smith on Fri Dec 17, 2010 8:18 am

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.

Jeff Smith

Posts: 311
Join date: 2009-02-03

View user profile

Back to top Go down

View previous topic View next topic Back to top

- Similar topics

Permissions in this forum:
You cannot reply to topics in this forum