How to Get Sql server Data file and Log file Size

sql server Data file and Log file Size in MB and also new function for select case instead of NullIf

In sql server 2000 and 2005 more than people using select case .

Select case when Temp_Name is null or Temp_Name='' then 'No Name' else Temp_Name End as TEmp_Name from TblTemp

Instead of using case you can user null if function

Select isnull(nullif(Temp_Name,''),'No Name')Temp_Name from TblTemp

you are also get same result from both query.

how to get size of sql server  log file and data file in MB

SELECT database_id, CONVERT(VARCHAR(25), DB.name) AS dbName, (SELECT SUM((size*8)/1024) FROM sys.master_files WHERE DB_NAME(database_id) = db.name AND type_desc = 'rows') DATA_MB, (SELECT SUM((size*8)/1024) FROM sys.master_files WHERE DB_NAME(database_id) = db.name AND type_desc = 'log') AS [Log MB] FROM sys.databases DB WHERE name in (select name from sys.databases)