To see the size of a table and its indexes, use:
sp_spaceused titles, 1
See “Calculating the sizes of data-only-locked tables” for information on estimating the size of the clustered index.
