Reducing Database Size by Using Vardecimal Storage Format

  • Article

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 :)