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 = 2 + ((Num_Cols + 7) / 8)
some body please explain what is "Max_Var_Size" and If I want move the Data(lets say 10000 row) shall I calucalate the Indexing on the table also?
Basically I want calucalate how much data moving from One DB(Sevrer1) to DB(Server2).
December 20, 2008 2:22 PM
December 22, 2008 8:22 PM