SQL SERVER - Get the total Rows,reserved space, Data, Index Size, and Unused Space of Table

Some time we need to know the table object details so sql server provided the Sp_spaceused to get the details of table.

 

-- select Database

Use AdventureWorks

GO

-- Get the total Rows,reserved space, Data, Index Size, and Unused

-- Space of Table Object

sp_spaceused 'person.contact'

GO

Result : 

name      rows     reserved     data          index_size         unused

-----------------------------------------------------------------------

Contact   19972    6872 KB      4568 KB       1968 KB            336 KB

Try this one once..