Checking space used for tables and indexes

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.