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

Question

Hello guys,

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

Please give me your feedback........

Thanks in advance..........

Answer 1

Calculate the total header size
Calculate the available dataspace per data block
Calculate the combined column lengths of the average row
Calculate the total average row size.
Calculate the average number rows that can fit in a block
Calculate 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.