Data Compression before or after loading operations? [SQL Server]
Based on what we have experienced, it appears that its more efficient to just immediately insert into a compressed table, with a partitioned clustered index.
Tech enthusiast blogs about technology, databases, media, gadgets and communities
Based on what we have experienced, it appears that its more efficient to just immediately insert into a compressed table, with a partitioned clustered index.
Row and Page Compression are features added to SQL Server 2008 and there are plenty of articles/blogs that discuss about it. I had the opportunity to play with a particular table I needed to archive and gathered some statistics while in the process.