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 II
Microsoft SQL Server Manageability