SELECTOBJECT_NAME(B.OBJECT_ID)表名,B.NAME 索引名称,A.INDEX_TYPE_DESC 索引类型,ROUND(A.AVG_FRAGMENTATION_IN_PERCENT,2)碎片率FROMsys.dm_db_index_physical_stats(DB_ID(),NULL,NULL,NULL,NULL)AINNERJOINsys.indexes BONA.OBJECT_ID=B.OBJECT_IDANDA.INDEX_ID=B.INDEX_IDWHERE1=1ANDA.AVG_FRAGMENTATION_IN_PERCENT>30--AND A.AVG_FRAGMENTATION_IN_PERCENT>5 AND A.AVG_FRAGMENTATION_IN_PERCENT<=30ORDERBYOBJECT_NAME(B.OBJECT_ID),A.AVG_FRAGMENTATION_IN_PERCENTDESC
生成优化索引碎片语句
SELECTOBJECT_SCHEMA_NAME(B.OBJECT_ID)架构,OBJECT_NAME(B.OBJECT_ID)表名,B.NAME 索引名,ROUND(A.AVG_FRAGMENTATION_IN_PERCENT,2)碎片率,CASEWHENA.AVG_FRAGMENTATION_IN_PERCENT>30THENN'重新生成索引'ELSEN'重新组织索引'END处理方式,'ALTER INDEX '+QUOTENAME(B.NAME)+' ON '+QUOTENAME(OBJECT_SCHEMA_NAME(B.OBJECT_ID))+'.'+QUOTENAME(OBJECT_NAME(B.OBJECT_ID))+' '+CASEWHENA.AVG_FRAGMENTATION_IN_PERCENT>30THEN'REBUILD'ELSE'REORGANIZE'END生成SQL语句FROMsys.dm_db_index_physical_stats(DB_ID(),NULL,NULL,NULL,NULL)AINNERJOINsys.indexes BONA.OBJECT_ID=B.OBJECT_IDANDA.INDEX_ID=B.INDEX_IDWHEREA.AVG_FRAGMENTATION_IN_PERCENT>5ANDB.INDEX_ID>0--AND OBJECT_NAME(B.OBJECT_ID) IN ('INVMB') --指定表ORDERBYCASEWHENA.AVG_FRAGMENTATION_IN_PERCENT>30THENN'重新生成索引'ELSEN'重新组织索引'END,OBJECT_NAME(B.OBJECT_ID),B.INDEX_ID
一、前言
新手朋友先搞懂：Xshell 和 Xftp 都是 Windows 能装的，跟 Linux 服务器搭配用的！想远程操控服务器、敲命令（比如启动程序、查配置），用 Xshell；想传文件（本地→服务器&#…
AI Agent，最近火得一塌糊涂。
Sam Altman 曾这样描述未来的AI Agent：“今天的AI模型是它们将会是的最‘笨’状态，未来只会越来越聪明！” 吴恩达在AI Ascent 2024会议上也不吝赞美：“这是AI发展的黄金时代，…
过去一年，构建 AI Agent（智能体）通常意味着一套固定流程：搭建循环机制，接收用户指令、调用大语言模型（LLM），解析工具调用需求，执行工具，将结果回传࿰…
