03 2021 档案

设置 清理 SQL SERVER LOG
摘要：EXEC master..xp_instance_regwrite @rootkey='HKEY_LOCAL_MACHINE', @key='Software\Microsoft\MSSQLServer\MSSQLServer', @value_name='DefaultLog', @type=RE 阅读全文
posted @ 2021-03-03 14:41 欣欣点灯 阅读(122) 评论(0) 推荐(0) 编辑
查询SQL server 对象存储信息
摘要：SELECT OBJECT_NAME(i.object_id) AS objectName, i.name AS indexName, SUM(a.total_pages) AS totalPages, SUM(a.used_pages) AS usedPages, SUM(a.data_pages 阅读全文
posted @ 2021-03-01 10:39 欣欣点灯 阅读(124) 评论(0) 推荐(0) 编辑

点击右上角即可分享
微信分享提示