Home
Kimball Group Home
Search
Register
Log inSQL Server 2008, page compression and indexing
Page 1 of 1
SQL Server 2008, page compression and indexing
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.
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
Similar topics» SQL Server 2008 - CHAR and table compression vs VARCHAR in Dimension Tables
» Fact Indexing -SQL Server 2008
» 1 instance or 2 in SQL Server 2008
» rule of thumb regarding log space for SQL Server 2008
» What are some Best Practices to ETL from Excel to SQL Server 2008?
» Fact Indexing -SQL Server 2008
» 1 instance or 2 in SQL Server 2008
» rule of thumb regarding log space for SQL Server 2008
» What are some Best Practices to ETL from Excel to SQL Server 2008?
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum