Determing SQL Server Table Size

This is a bit of code I found that determines the size used by each table in your database. Make sure you run DBCC UPDATEUSAGE first to correct any incorrect stats (pages etc) on your tables. DBCC UPDATEUSAGE (YOUR DATABASE NAME) DECLARE @TableName VARCHAR(100)    –For storing values in the cursor –Cursor to get the [...]

Tags: SQL Server