摘要:
-- Script to analyze table space usage using the-- output from the sp_spaceused stored procedure-- Works with SQL 7.0, 2000, and 2005set nocount onprint 'Show Size, Space Used, Unused Space, Type, and Name of all database files'select [FileSizeMB] = convert(numeric(10,2),sum(round(a.size/128 阅读全文