Viewing 3 posts - 61 through 63 (of 63 total)
Ok, this is starting to make a little more sense now. Yes, the indexes in question are clustered indexes.
However, the # of rows updated is relatively small. Here's...
March 10, 2009 at 2:46 pm
#957097
Gail,
The AUTO_SHRINK option is OFF. I do not manually shrink any of the db files. (I doubt anyone else in my organization does this.)
The indexed column(s) in question...
March 10, 2009 at 2:21 pm
#957080
MJ,
I rebuild indexes once per day at 6am. On some days, a second index rebuild is required.
March 10, 2009 at 2:02 pm
#957066