--找出所有非xml索引DECLARE cur CURSOR FORSELECT[object_name]=s.name '.' OBJECT_NAME(A.object_id),B.nameFROM sys.dm_db_index_physical_stats(DB_ID('Adve......
--重整所有索引，在这里先不管索引的碎片程度 WHILE@@FETCH_STATUS=0 BEGIN SET@sql='ALTER INDEX '@indname' ON '@objname' REBUILD'; EXEC(@sql); FETCHNEXTFROM cur INTO@objname,@indname; END
