Running the initial script creates three tables dba_indexDefragLog, dba_indexDefragStatus and dba_indexDefragExclusion, creates a stored procedure [dba_indexDefrag_sp] and adds a function that the stored proc uses.

Once these are in place, simply...

Just a thought - and it may not apply in your case - but could the issues be caused by parallelism and/or your isolation level?

Our OLTP ran into...

Any advice on what to do if it was data skew (as you mentioned earlier)?

How would this apply to a heap?

Cheers,

Paul

Getting back onto the theme of the original post.

If 0.999 recurring = 1, then does 0.00...1 = 0?

The issue I have with 0.999 recurring = 1 is that...