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: http://msdn2.microsoft.com/en-us/library/bb508963.aspx.


Paul A. Mestemaker II
Program Manager
Microsoft SQL Server Manageability

Comments (2)

  1. Glenn Berry says:

    Very nice whitepaper that does an excellent job of explaining how vardecimal storage works and the tradeoffs that it involves.

  2. RPagadala says:

    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 🙂