有用的T-SQL语句收集
关键字：
/** 查询最大的表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
[分区分表方案.sql][1]
[分区分表方案_inv.sql][2]
[sql.rar][3]
[1]: https://rongyi.site/usr/uploads/2023/04/3402413585.sql
[2]: https://rongyi.site/usr/uploads/2023/04/1356516557.sql
[3]: https://rongyi.site/usr/uploads/2023/04/3499826237.rar