Enabling vardecimal storage format

Estimating the space savings with vardecimal storage format

SQL Server Storage Engine — Mon, 13 Nov 2006 19:49:39 GMT

Before enabling Vardecimal storage format, you may want to know the potential reduction in the size of

Come abilitare vardecimal datatype

SQL Server, BI — Mon, 04 Dec 2006 14:27:05 GMT

re: Enabling vardecimal storage format

xmldeveloper — Fri, 29 Dec 2006 12:05:47 GMT

Disabling the vardecimal storage format for a database requires SIMPLE recovery model.

Why?

This can have implications on the backup/restore strategy for that database.

re: Enabling vardecimal storage format

Sunil Agarwal — Fri, 29 Dec 2006 23:59:45 GMT

Please refer to the latest BLOG on this. Can you please elaborate on the backup/restore scenario that you have in mind.

thanks

Sunil

re: Enabling vardecimal storage format

xmldeveloper — Sat, 30 Dec 2006 12:07:27 GMT

I understood the reason now. The log chain is broken when the database is moved to a less advanced version (removing vardecimal). Then switching to simple recover mode indicates the need for a new backup.

SQL Server 2005 SP2 では、decimal, numeric データ型利用時のディスクスペースが減る !? vardecimal とは.

河端善博の .TEXT でウェブログ — Wed, 07 Feb 2007 15:42:43 GMT

SQL Server 2005 SP2 では、decimal, numeric データ型利用時のディスクスペースが減る !? vardecimal とは.