2,187
edits
m (→Fragmentation: Updated rebuilds for 2008) |
m (→Fragmentation: added ent note) |
||
Line 187: | Line 187: | ||
ALTER INDEX IndexName ON TableName REORGANIZE; /* Online */ | ALTER INDEX IndexName ON TableName REORGANIZE; /* Online */ | ||
ALTER INDEX IndexName ON TableName REBUILD; /* Offline */ | ALTER INDEX IndexName ON TableName REBUILD; /* Offline */ | ||
ALTER INDEX IndexName ON TableName REBUILD WITH (ONLINE = ON) | ALTER INDEX IndexName ON TableName REBUILD WITH (ONLINE = ON); /* Online - 2008 Ent and above only */ | ||
</source> | </source> | ||
Line 199: | Line 199: | ||
...or the REBUILD statements... | ...or the REBUILD statements... | ||
<source lang="sql"> | <source lang="sql"> | ||
SELECT 'ALTER INDEX ' + ind.name + ' ON ' + OBJECT_NAME(ind.OBJECT_ID) + ' REBUILD WITH (ONLINE = ON) | SELECT 'ALTER INDEX ' + ind.name + ' ON ' + OBJECT_NAME(ind.OBJECT_ID) + ' REBUILD WITH (ONLINE = ON);' | ||
FROM sys.dm_db_index_physical_stats(DB_ID(), NULL, NULL, NULL, NULL) indexstats | FROM sys.dm_db_index_physical_stats(DB_ID(), NULL, NULL, NULL, NULL) indexstats | ||
INNER JOIN sys.indexes ind ON ind.object_id = indexstats.object_id AND ind.index_id = indexstats.index_id | INNER JOIN sys.indexes ind ON ind.object_id = indexstats.object_id AND ind.index_id = indexstats.index_id |