• Perry Whittle (9/19/2012)


    sql-lover (9/19/2012)


    -I am using smart ReIndex

    -The ReIndex will run for 1st time

    How do you know? Unless you force reindex you could end up reorging some indexes and this will bloat the log for sure!

    Sorry, I mean, the job will run for 1st time. If it will do a reoganize or reindex, it depends.

    However, based on the amount of pages (for the big tables) and the fragmentation I've seen inside, I am almost sure a ReIndex will be triggered, instead of a reorganize. This is not the 1st big database without a job that I am trying to put in good shape and that has been the default behavior so far. However, the Tlog resides on a logical drive that does not have plenty of space.

    So, is my math above correct? 🙂