Just run this query:

SELECT * FROM master..sysaltfiles ORDER BY size DESC

Advertisements