Wednesday, April 13, 2011

How to get spaced used by a specific table in sql server

its very simple , just need to call this following sp with table name as argument.

exec sp_spaceused 'TableName' and it will return following fields.

name             rows             reserved                data                 index_size    unused
TableName  38701          206912 KB            188088 KB    248 KB          18576 KB

No comments:

Post a Comment