P.s.

I spotted a mistake in my original code too...

I am joining on the sys.tables and sys.indexes tables when pulling back the index data - this doesn't work because it...

😀 Hehe, ok-ok, so I was being lazy - I will try, I have a similar sproc which does the re-organzing although I am likely going to use the FOOL...

Understood - I think this is exactly what I am experiencing.

The avg fragmentation on some of these indexes is 100% however they have a page count of 2 so as...

Thanks for the prompt reply - I've checked out the page counts on each and they seem really low (12 or less) so I'm guessing that could be it.

Yes! I...