2,187
edits
Difference between revisions of "MS SQL"
Jump to navigation
Jump to search
m
→Fragmentation: Updated rebuilds for 2008
m (→Commands and Maintenance: added execute sp_who2;) |
m (→Fragmentation: Updated rebuilds for 2008) |
||
| 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)*; /* Online - 2008 and above only */ | |||
</source> | </source> | ||
| Line 198: | 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;' | 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 | ||