SQL
lin557
读书笔记
展开
-
MSSQL中查表锁定与表解锁
select OBJECT_NAME(resource_associated_entity_id) As TableName, * from sys.dm_tran_locks where resource_type = 'OBJECT' kill 67 百度找的,出处转载 2011-10-10 17:23:29 · 448 阅读 · 0 评论 -
MSSQL中查所有表数据大小
DECLARE @tablespaceinfo TABLE ( nameinfo varchar(50), rowsinfo int, reserved varchar(20), datainfo varchar(2转载 2011-10-10 17:21:56 · 747 阅读 · 0 评论