Browse by Tags

• White Paper: Reducing Database Size by Using Vardecimal Storage Format

  Hermann Daeubler and Sunil Agarwal have co-authored this white paper. Hermann is a Program Manager with the SQL team and is a SAP expert. Hermann was involved with vardecimal storage format team from the very beginning to guide us with the customer scenarios Read More... Posted Tuesday, May 29, 2007 11:11 PM by Sunil Agarwal | 1 Comments Filed under: VarDecimal Storage Format

• Data row before and after vardecimal storage format

  Paul Randal in one of his earlier BLOGs described DBCC Page paul-tells-all and the record layout. I thought it will be interesting to show how a row looks before and after the Vardecimal storage format is enabled. So here it is Let us take a simple table Read More... Posted Sunday, January 07, 2007 3:22 AM by Sunil Agarwal | 1 Comments Filed under: VarDecimal Storage Format

• Boundary conditions for enabling vardecimal storage format

  Have you ever tried updating a variable length column and fail? Well, it can happen if the modified row cannot fit on the page. One simple example of this as follows create table boundary (c1 char(8000), c2 char(20), c3 varchar(23), c4 decimal(38,2)) Read More... Posted Friday, January 05, 2007 2:45 AM by Sunil Agarwal | 4 Comments Filed under: VarDecimal Storage Format

• Vardecimal Storage Format and its implications on Backup/Recovery

  Has any one tried restoring or attaching a SQL Server 2005 database on SQL Server 2000? You will find that SQL Server 2000 will fail this restore or attach. The reason is simple. SQL Server 2000 does not understand the physical structure changes in SQL Read More... Posted Friday, December 29, 2006 8:54 PM by Sunil Agarwal | 4 Comments Filed under: VarDecimal Storage Format

• Enabling vardecimal storage format

  First, this feature is only available in EE and Dev SKU. Enabling vardecimal storage format on a table is a two step process as follows: First you need to enable database for Vardecimal storage format. This can be done using the stored procedure s p_db_vardecimal_storage_format. Read More... Posted Monday, November 13, 2006 4:33 PM by Sunil Agarwal | 6 Comments Filed under: VarDecimal Storage Format

• Estimating the space savings with vardecimal storage format

  Before enabling Vardecimal storage format, you may want to know the potential reduction in the size of the table. Clearly, if the table has no decimal/numeric columns, there will be no savings. Note, that even if you have a table with decimal/numeric Read More... Posted Monday, November 13, 2006 2:33 AM by Sunil Agarwal | 2 Comments Filed under: VarDecimal Storage Format

• Reducing the Size of your Database in SQL Server 2005/SP2

  An exciting new feature in SQL Server 2005/SP2 is Vardecimal Storage Format. This storage format lets you reduce the size of your table significantly if the table has one of more columns of type decimal or numeric without requiring any changes to your Read More... Posted Friday, November 10, 2006 5:48 PM by Sunil Agarwal | 2 Comments Filed under: VarDecimal Storage Format