DBCC UpdateUsage(0) WITH NO_INFOMSGS

DECLARE	@DbSize BIGINT,
	@LogSize BIGINT,
	@ReservedPages BIGINT

SELECT	@DbSize = SUM(CONVERT(BIGINT, CASE WHEN Status & 64 = 0 THEN Size ELSE 0 END)),
	@LogSize = SUM(CONVERT(BIGINT, CASE WHEN Status & 64 = 0 THEN 0 ELSE Size END))
FROM	dbo.SysFiles

SELECT		@ReservedPages = SUM(a.Total_Pages)
FROM		sys.Partitions AS p
INNER JOIN	sys.Allocation_Units AS a ON p.Partition_ID = a.Container_ID
LEFT JOIN	sys.Internal_Tables AS it ON p.Object_ID = it.Object_ID

SELECT	DB_NAME() AS DbName,
	LTRIM(STR(8192.0 * (@DbSize + @LogSize) / 1048576.0, 15, 2) + ' MB') AS DbSize,
	LTRIM(STR(CASE WHEN @DbSize >= @ReservedPages THEN 8192.0 * (@DbSize - @ReservedPages) / 1048576.0 ELSE 0.0 END, 15, 2) + ' MB') AS [Unallocated space]

SELECT		COALESCE(Items.Item, 'Total companies') AS Company,
		Items.Records,
		(Items.Records * RecordSize) / 1048576 AS Used
FROM		(
			SELECT		Company AS Item,
					COUNT(*) AS Records
			FROM		Table1
			GROUP BY	Company
			WITH ROLLUP
		) AS Items
CROSS JOIN	(
			SELECT	SUM(
					CASE DATA_TYPE
						WHEN 'TINYINT' THEN 1
						WHEN 'SMALLINT' THEN 2
						WHEN 'INT' THEN 8
						WHEN 'BIGINT' THEN 16
						WHEN 'SMALLDATETIME' THEN 4
						WHEN 'DATETIME' THEN 8
						-- Add more WHEN here when needed
						WHEN 'UNIQUEIDENTIFIER' THEN 16
						ELSE CHARACTER_MAXIMUM_LENGTH
					END
				) AS RecordSize
			FROM	INFORMATION_SCHEMA.COLUMNS
			WHERE	TABLE_NAME = 'Test'
		) AS RecordSize
ORDER BY	CASE
			WHEN Items.Item IS NULL THEN 1
			ELSE 0
		END,
		Items.Item