随笔分类 -  SQL数据库

SQL的数据库
数据库中表的死锁和解锁
摘要：死锁： select request_session_id spid,OBJECT_NAME(resource_associated_entity_id) tableName from sys.dm_tran_locks where resource_type='OBJECT' spid 锁表进程 阅读全文
posted @ 2020-10-20 10:54 JokerYin 阅读(252) 评论(0) 推荐(0)
SQL的存储过程授权和回收
摘要：授权：grant execute on xp_dirtree to public 回收：revoke execute on xp_dirtree from public 阅读全文
posted @ 2020-10-20 10:34 JokerYin 阅读(255) 评论(0) 推荐(0)
SQL Server 数据库查看表占用内存
摘要：SELECT top 10 t.NAME AS TableName, p.rows AS RowCounts,--数据量 SUM ( a.total_pages ) * 8 AS TotalSpaceKB,--空间总内存KB CAST ( ROUND((( SUM ( a.total_pages ) 阅读全文
posted @ 2020-07-31 11:36 JokerYin 阅读(979) 评论(0) 推荐(0)