Could you hire me? Contact me if you like what I’ve done in this article and think I can create value for your company with my skills.

November 7, 2006 / by Zsolt Soczó

SQL 2005 SP2 CTP

Readme.
Ami nekem érdekes:

Added new functionality in the SQL Server 2005 Enterprise Edition to provide an alternate storage format that can be used to minimize the disk space needed to store existing decimal and numeric data types. No application changes area are required to use its benefits. This new storage format, known as vardecimal storage format, stores decimal and numeric data as variable length columns and can be enabled or disabled at a table level on new or existing tables. If you have declared a decimal or numeric column with high precision but most values do not require it, you can potentially save the disk space needed to store the table. A new stored procedure is provided to estimate the reduction in average row size with the new storage format.

A Vistához kell majd az SP2.
Letölthető verziót még nem találtam.

Could you hire me? Contact me if you like what I’ve done in this article and think I can create value for your company with my skills.