T-SQL实用查询之分析数据库表的大小

时间:2015-08-27 00:00:22   收藏:0   阅读:335
IF OBJECT_ID(tempdb..#TB_TEMP_SPACE) IS NOT NULL DROP TABLE #TB_TEMP_SPACE
GO
CREATE TABLE #TB_TEMP_SPACE(
    NAME VARCHAR(500)
    ,ROWS INT
    ,RESERVED VARCHAR(50)
    ,DATA VARCHAR(50)
    ,INDEX_SIZE VARCHAR(50)
    ,UNUSED VARCHAR(50)
)
GO
SP_MSFOREACHTABLE INSERT INTO #TB_TEMP_SPACE exec sp_spaceused ‘‘?‘‘‘
GO
SELECT *
    FROM #TB_TEMP_SPACE
    ORDER BY REPLACE(DATA,KB,‘‘)+0 DESC
GO 

 

原文:http://www.cnblogs.com/coce/p/4761895.html

评论(0
© 2014 bubuko.com 版权所有 - 联系我们:wmxa8@hotmail.com
打开技术之扣,分享程序人生!