Monday, July 16, 2012

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..


Like and Share to SQL Integrity Blog

No comments:

Post a Comment

Thank You !!!!