To get a rough view of how many rows, total, used and unused space each table has, in a sql server database you can run the following query: [crayon-583450f43d6a5734372322/] Another way is using the stored procedure sp_spaceused which displays the number of rows, disk space reserved, and disk space used by a table, indexed view, or Service Broker ...