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 12:18 pm

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 : 471
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