I have a fairly large table, which I have to keep up, with some very, very fragmented indices. This seems to be causing problems with performance. I would like to have neat fresh crisp indices on this table. I also have some rather annoying restrictions: 1. At no time can this table become unavailable. 2. I don't have Sql Server enterprise edition (i.e. no online rebuilding of indices)
What is my best course of action? Just try and reorganise them? How long would this roughly take on a table with about 600k rows, on moderate hardware? (answers within an order of magnitude are precise enough)