How will you estimate the space required by a non-clustered tables?

 Calculate the total header sizeCalculate the available dataspace per data blockCalculate the combined column lengths of the average rowCalculate the total average row size.Calculate the average number rows that can fit in a blockCalculate the number of blocks and bytes required for the table. After  arriving the calculation, add 10 % additional space to calculate the initial extent size for a working table.


This Question is not yet answered!


Related Answered Questions


Related Open Questions