locked
Index fragmentation problem within SQL 2008. its nto reducing fragmentation ! RRS feed

  • Question

  • I have a problem with index fragmentation within SQL 2008, I keep running a script that looks at the fragmentation levels on tables on the database and if the fragmentation level is less than 30, it issues an index reorganise command, if the fragmentation level is over 30, it issues an index rebuild command. One thing I have noticed though is that no matter how many times I run the command, the fragmentation figure doesn’t change at all.

     

    It simply does a rebuild all the time. Most of the time, the column in question tends to be varchar columns. Is there any reason for this ?

    Thursday, November 12, 2009 9:20 AM

Answers

All replies