Export (0) Print
Expand All
2 out of 4 rated this helpful - Rate this topic

Estimating the Size of a Table

You can use the following steps to estimate the amount of space required to store data in a table:

  1. Calculate the space required for the heap or clustered index following the instructions in Estimating the Size of a Heap or Estimating the Size of a Clustered Index.
  2. For each nonclustered index, calculate the space required for it by following the instructions in Estimating the Size of a Nonclustered Index.
  3. Add the values calculated in steps 1 and 2.
Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.