Max_Var_Size Questions

1

Moving data from one DB to another DB in SQL Server 2005
Hi all I got formula to calucalate Row_size of a table Row_Size = Fixed_Data_Size + Variable_Data_Size + Null_Bitmap + 4 Fixed_Data_Size = total byte size of all fixed-length columns Variable_Data_Size = 2 + (Num_Variable_Cols x 2) + Max_Var_Size Num_Variable_Cols = number of variable-length columns Max_Var_Size = maximum byte size of all variable-length columns Null_Bitmap = [...]

Answer Question   |  December 22, 2008  2:22 PM
Data migration, Max_Var_Size, SQL Server 2005, SQL Server 2005 migration, SQL Server migration
asked by:
20 pts.

1