Shulou(Shulou.com)06/01 Report--

with fs

as

(

select database_id, type, size * 8.0 / 1024 size

from sys.master_files

)

select

name,

(select cast(round(sum(size),2) as numeric(15,2)) from fs where type = 0 and fs.database_id = db.database_id) DataFileSizeMB,

(select cast(round(sum(size),2) as numeric(15,2)) from fs where type = 1 and fs.database_id = db.database_id) LogFileSizeMB

from sys.databases db

order by 2 desc;

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.