Soci (Soczó Zsolt) szakmai blogja


SQL 2005 SP2 CTP

Filed under: Adatbázisok,SQL Server 2005,Szakmai élet — Soczó Zsolt @ 21:55

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.

No Comments

No comments yet.

RSS feed for comments on this post.

Sorry, the comment form is closed at this time.

Powered by WordPress