Wednesday, December 26, 2012

Check DB Table Size (sp_spaceused)

sp_spaceused
Displays the number of rows, disk space reserved, and disk space used by a table, indexed view, or Service Broker queue in the current database, or displays the disk space reserved and used by the whole database.

Example
EXEC sp_spaceused N'Sales.SalesPerson';

Result