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).
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!