Estimate the Size of a Table
Applies To: SQL Server 2016
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.