Tag Info

New answers tagged


It is certainly possible to use a Maintenance Plan to handle the fragmentation issues. However, many people use the free scripts at: http://ola.hallengren.com/sql-server-index-and-statistics-maintenance.html I am part of the 'many people'. These scripts by default implement the suggested standards for reducing the fragmentation of indexes. So, if you ...


My experience is that it is always going to do an online rebuild in the filegroup on which the index lives. It has to map the existing index and hold enough space for, essentially, one copy. You should only be getting the error when an index which is too large to hold mappings (the copy) is rebuilt - for instance, one time it may be fragmented enough to ...

Top 50 recent answers are included