Dude, where's my database?

Ultra-brief post today.

If you need to know what physical file(s) are associated with what
databases, then sys.master_files is the view for you.
http://msdn.microsoft.com/en-us/library/ms186782.aspx Plenty of handy
information there but physical_name is where you can determine what
mdf file(s) a database is using and where they are located on the file
system.