With this exercise we have effectively increased performance at the expense of maintenance. Well worth the change.
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.
You might already know that MP3 is a lossy format right? Portions of the original song get thrown away, yes.