跟小D每日学口语
2011年4月20日
Script to analyze table space usage
摘要： -- 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 阅读全文
posted @ 2011-04-20 11:54 Danny Chen 阅读(280) 评论(0) 推荐(0)