I had a question as I started planning this. In SQL 2005, I hear that we can not do a reindex while users are in the database, but you can 'get away' with defragging while users are in there.
Is this correct?
And, are the SQL 2008 reindex/defrag conditions the same?
View Complete Post