2008

Database
SQL Server

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.

Read More
Database
SQL Server

Playing with Page Level Compression and Indexes

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.

Read More