Reducing Database Size by Using Vardecimal Storage Format
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: https://msdn2.microsoft.com/en-us/library/bb508963.aspx.
Paul A. Mestemaker II
Program Manager
Microsoft SQL Server Manageability
Comments
Anonymous
May 29, 2007
Very nice whitepaper that does an excellent job of explaining how vardecimal storage works and the tradeoffs that it involves.Anonymous
January 31, 2010
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 :)