05 2022 档案
查看SQLSERVER邮件配置 sp_send_dbmail profile
摘要：获取如下图所示，参考官方链接：https://docs.microsoft.com/zh-cn/sql/relational-databases/database-mail/create-a-database-mail-account?view=sql-server-ver16
阅读全文
查询SQLSERVER语句执行日志
摘要：SELECT TOP 1000--创建时间QS.creation_time,--查询语句SUBSTRING(ST.text,(QS.statement_start_offset/2)+1,((CASE QS.statement_end_offset WHEN -1 THEN DATALENGTH(s
阅读全文
重建SQLSERVER索引
摘要：查询碎片率 SELECT a.index_id ,B.name [IndexName] ,avg_fragmentation_in_percent FROM sys.dm_db_index_physical_stats ( DB_ID() , NULL , NULL, NULL, NULL ) AS
阅读全文
查询SQLSERVER表行数
摘要：select a.name as '表名',b.rows as '表数据行数'from sysobjects a inner join sysindexes bon a.id = b.idwhere a.type = 'u'and b.indid in (0,1)--and a.name not l
阅读全文
