Data File Size for all Databases!
A useful query to find the size of each data file in your database instance
IF OBJECT_ID(‘DatabaseFiles’) IS NULL
BEGIN
SELECT TOP 0 * INTO #DatabaseFiles
FROM sys.database_files
ALTER TABLE #DatabaseFiles
ADD CreationDate DATETIME DEFAULT(GETDATE())
END
EXECUTE sp_msforeachdb ‘INSERT INTO #DatabaseFiles SELECT *, GETDATE() FROM [?].sys.database_files’
SELECT name, cast((size * 8192.0 / 1024.0 /1024.0 / 1024.0) as decimal(10,3)) FROM #DatabaseFiles WHERE type_desc = ‘ROWS’ ORDER BY Size DESC