摘要:
CREATE PROCEDURE [dbo].[sp_who3] ( @SessionID INT = NULL ) AS BEGIN SELECT SPID = er.session_id ,STATUS = ses.STATUS ,[Login] = ses.login_name ,Host = 阅读全文
摘要:
SELECT a.name 数据表, b.rows 数据总条数 FROM sysobjects AS a INNER JOIN sysindexes AS b ON a.id = b.id WHERE ( a.type = 'u' ) AND ( b.indid IN ( 0, 1 ) ) ORDE 阅读全文
摘要:
alter table xxx rebuild sqlserver整理表碎片提升阅读性能 阅读全文