SQL Server: script to get database size and single... Peter Gfader's brain noise

SQL Server: script to get database size and single table size

CREATE TABLE #t 
	(name SYSNAME, 
	 rows CHAR(11), 
	 reserved VARCHAR(18), 
	 data VARCHAR(18), 
	 index_size VARCHAR(18), 
	 unused VARCHAR(18)) 
 
EXEC sp_msforeachtable 'INSERT INTO #t EXEC sp_spaceused ''?'''

SELECT *, 
		CONVERT(INT, SUBSTRING(data, 1, LEN(data)-3)) as datasizeInKB 
FROM #t 
		ORDER BY datasizeInKB desc, name 

DROP TABLE #t

9geek likes this
gfader posted this