The article has floated to the top of the headlines again, but still no update on results?

I would do a profiler trace of the DB activity during the time of occurance. Any number of things could be happening from common locking to more obscure problems like iterative recompilation...

I take it this is not a question, simply a public celebration

Congratulations

Otherwise I would think that a computed column would do what you want to do.

I would still think that either your rule is going to be more complex than...

If the rule is as simple as always adding 4 zeros to the front of an existing column, why not use a view instead of storing this information?

yes there are

although the pk on the parent isn't clustered

when I overlayed a non-clustered index on top of the ci, performance improved and was similar to the manual deletes performed...

On thinking about this could cascade delete be doing record based operations vs set based operations? (since my own constructed deletes would be using set based ops)

oops, wrong button

Also, not knowing the query which is being submitted....

The Set FORCEPLAN may be conflicting with your query hint (which is what the error message appears to be telling you)

SET...

The KB for the above comment is http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/Q293/1/77.ASP&NoWebContent=1

Not sure if you have tried running the index wizard on this, if so the wizard can create some statistics which do not always get deleted unless it is completed....

How about a partitioned view?

LOL, been there.

When will fingers learn to type whjat you mean, not whjat you typed.

1. SMTP with no dependency on LDAP

Download the scripting documentation at http://www.microsoft.com/scripting for documentation on the scripting.filesystemobject.