New answers tagged

2

For everyone interested, I have created a chart showing the index REBUILD duration of about 2500 index rebuilds within couple of weeks in relation to the fragmentation of the index and it's size in pages. This data is based on 10 SQL Servers, hundreads of tables and on Ola Hallengren's optimizing procedures. The general threshold for rebuilding is set to ...


2

Presuming the database is not actually "in-use" at the time this rebuild process starts Assuming what you are presuming, I don't what side-effect it could have, outside of the obvious allowing for index REORG to happen :-). Of course, I have no proof, but not sure what proof to look for that nothing bad will happen when nothing is happening in the DB ...



Top 50 recent answers are included