跟小D每日学口语
摘要: -- 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 阅读(269) 评论(0) 推荐(0) 编辑