Igor,

I doubt there is much else you can do. I would be interested in knowing if you do find a way of improving on this.

Also I would appreciate it if...

Igor,

How many indexes are included in your batch? I.e. are you defragging a number of indexes at a time or are you dealing with them on an individual basis?

What I...

OK guys - thanks for your input on that subject.

Anyone have anything else to discuss on the article?

Sreejith,

I did mention this point in the article. I am simply trying to illustrate the point of using the GETDATE() function and a cursor as one way of controlling when...

Thanks - that helps a little.

I also looked at the different effects each of the following has on Query Analyser's output. If you're interested you should play around with these...

I've worked it out. The value stored in sysindexes.first, sysindexes.root and sysindexes.firstiam can be turned into a file id and page number by splitting the value in two and then...