29 May 2007

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

Filed under: ,
 

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

# Glenn Berry said:

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

30 May 07 at 12:36 AM

Leave a Comment

Comment Policy: No HTML allowed. URIs and line breaks are converted automatically. Your e–mail address will not show up on any public page.

(required) 
(optional)
(required) 

  
Enter Code Here: Required

About Paul Mestemaker

I am a Program Manager on the SQL Server Manageability Team at Microsoft. I am a proud University of Michigan alumnus. I graduated with a business degree from the Stephen M. Ross School of Business in 2005.
Page view tracker