How to Get Sql server Data file and Log file Size

Dhaval Patel
13y
8.1k
0
0

Blog

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)