Getting the Physical Location of the MDF and LDF Files in SQL Server

SELECT name, physical_name
FROM sys.master_files;