compression

Database
SQL Server

Table Structure, Trading Maintenance with Performance [SQL Server]

With this exercise we have effectively increased performance at the expense of maintenance. Well worth the change.

Read More
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
Encoding
Media

Compress your music to a lossless format

You might already know that MP3 is a lossy format right? Portions of the original song get thrown away, yes.

Read More