当SQL Server中有多个数据库的时候，通过图形界面查看数据库大小就很不方便，可以使用如下脚本迅速的查询所有数据库的大小：http://www.cndba.cn/cndba/dave/article/2824

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

版权声明：本文为博主原创文章，未经博主允许不得转载。