What is the vardecimal data type in SQL Server?


Databases grow rapidly every day. That is a simple fact. When we are in charge of administrating a large database, storage space is always a concern. We would like to know all these ways and techniques that will enable us to use our storage space as efficiently as possible.

A  new data type was introduced in SQL Server 2005 SP2(Service Pack 2 must be installed).We can use this new data type to reduce the size of a database.

It is called vardecimal. The vardecimal data type is used to store the Numeric/Decimal(data types with fixed precision and scale) data types. The vardecimal works the same way as the varchar works for the alphanumeric data. Basically it is a form of compression.Vardecimal data type can be very useful in a situation like this.

In some cases we can have have a decimal/numeric column with a precision scale (30,4), then each value will need 17 bytes of storage so…

Ver la entrada original 253 palabras más


Autor: Diego Flores

Diego Flores, DBA en Isapre Nueva Masvida. Concepción, Región del Bio Bio, Chile.


Introduce tus datos o haz clic en un icono para iniciar sesión:

Logo de WordPress.com

Estás comentando usando tu cuenta de WordPress.com. Cerrar sesión /  Cambiar )

Google+ photo

Estás comentando usando tu cuenta de Google+. Cerrar sesión /  Cambiar )

Imagen de Twitter

Estás comentando usando tu cuenta de Twitter. Cerrar sesión /  Cambiar )

Foto de Facebook

Estás comentando usando tu cuenta de Facebook. Cerrar sesión /  Cambiar )


Conectando a %s