Estimate the Size of a Table
You can use the following steps to estimate the amount of space required to store data in a table:
For each nonclustered index, calculate the space required for it by following the instructions in Estimate the Size of a Nonclustered Index.
Add the values calculated in steps 1 and 2.
We are listening: If you find something outdated or incorrect in this article, such as a step or a code example, please tell us. You can click the This page button in the Feedback section at the bottom of this page. We read every item of feedback about SQL, typically the next day. Thanks.