How Will You Estimate The Space Required By A Non-clustered Tables?

1.	How Will You Estimate The Space Required By A Non-clustered Tables?
Answer» 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.

Answer»

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.

Discussion