In addition to the improvements to the management tools in Service Pack 2 that I've outlined on this blog, the engine team has introduced the VarDecimal storage format. They have just published a whitepaper on how to reduce your database size. Check it out: http://msdn2.microsoft.com/en-us/library/bb508963.aspx.
Paul A. Mestemaker IIProgram ManagerMicrosoft SQL Server Manageability
Very nice whitepaper that does an excellent job of explaining how vardecimal storage works and the tradeoffs that it involves.
Nice to know that data compression using vardecimal. Bit long article, I have to come back again and read this article. So much to learn :)