Hello All,
The below query gives me a list with the data and log file sizes. This gives me duplicate rows for each database.
How can I fix it?
SELECT name AS [DB Name]
,[physical_name] AS [File Name]
,[ROWS] AS [Data File]
,[LOG] AS [Log File]
,GETDATE() AS [Run Date]
FROM (SELECT db.name
,dbf.[physical_name]
,dbf.[Size]
,type_desc
FROM sys.[databases] AS db
LEFT OUTER JOIN sys.[master_files] AS dbf ON [db].[database_id] = [dbf].[database_id]
) ps
PIVOT (SUM([Size]) FOR type_desc IN ([ROWS], [LOG])) AS pvt
List the file sizes
Posted - 10/10/2012 : 11:36:19
