Here is script to get the File Sizes of your db files:
The results are ordered by the file size descending.
So you can see what’s taking up all your hard drive space.
select physical_name, size, CONVERT(DECIMAL(10,2),(size * 8.00) / 1024.00) As UsedSpace
from master.sys.master_files
order by size desc
This post first appeared on Random Technical Thoughts | Things I Want To Remem, please read the originial post: here