xmldeveloper:
"Note: Vardecimal is a storage format, not a data type. [...] To enable vardecimal storage format for decimal data types using Management Studio, use the Database Properties Options Page to enable the vardecimal storage format in the database, and then use the Table Properties General Page, to enable the vardecimal storage format in the appropriate tables."
"Use the vardecimal storage format when you have a shortage of disk space, when disk access (I/O) is a bottleneck on system performance, or when you require a high level of precision for some of the data, even though many of the values are small, NULL, or zero (such as a table in a data warehouse with a decimal column that has many rows contain zero or integer values)."
"Databases using vardecimal storage format must be set to the simple recovery model."
Razvan