Answers

Question and Answer:

  Home  Memory Management

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

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.

 126 views

More Questions for you: