Kimball Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.

SQL Server 2008, page compression and indexing

Go down

SQL Server 2008, page compression and indexing Empty SQL Server 2008, page compression and indexing

Post  Jeff Smith 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

Back to top Go down

Back to top

- Similar topics

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