posted on Wednesday, November 08, 2006 12:06 AM
by
SimonSabin
SQL Server 2005 SP2 - Its not just bug fixes
My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/SQL Server 2005 SP2 - Its not just bug fixes
The new RSS feed is here
By no means is SP2 just a set of bug fixes. A couple of highlights of whats news
"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."
... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/SQL Server 2005 SP2 - Its not just bug fixes