/ 查询最大的表TOP10 / -begin
if object_id('tempdb..#Tab') is not null
drop table #Tab
CREATE TABLE #Tab (NAME nvarchar(100) ,ROWS VARCHAR(100) ,reserved nvarchar(100) ,Data nvarchar(100) ,index_size nvarchar(18) ,Unused nvarchar(18) )
GO
INSERT #Tab EXEC SP_MSFOREACHTABLE 'EXEC sp_spaceused "?"'
SELECT top 10 a.NAME as '名称',a.rows ,a.Data as '容量',a.index_size as '索引大小'
-- CONVERT(INT,REPLACE(DATA,'KB','')) 按容量排序
FROM #Tab a ORDER BY CONVERT(INT,REPLACE(DATA,'KB','')) DESC
/ 查询最大的表TOP10 / -end
/ 查询死锁 / -begin
--查询
select request_session_id spid,OBJECT_NAME(resource_associated_entity_id) tableName
from sys.dm_tran_locks where resource_type='OBJECT'
/ 查询死锁 / -end
