Saturday, August 1, 2009

Vardecimal - Estimating Space Savings

Could you benefit from space savings by using the VARDECIMAL data type?

This dynamic sql will help you find out....
SELECT 'exec sys.sp_estimated_rowsize_reduction_for_vardecimal ''' +schema_name(schema_id) + '.' + name +'''' FROM sys.objects WHERE type = 'u' ORDER BY 1


Link : http://blogs.msdn.com/sqlserverstorageengine/archive/2006/11/13/estimating-the-space-savings-with-vardecimal-storage-format.aspx

No comments: