I'm very sorry to have to tell you that it fails with partitioned objects on SQL2005.

I've tested it on an x64 EE SP2 CU2 4-socket-dualcore 16Gb

I have added the zipped sollution (attachement).

Even OPTION (maxdop 1) does not correct it !

This does not devalue the article !

We have to keep on testing and being creative in finding solutions to problems !

I like the way this article did set many of us on to reflecting about the way our DBMS engine works and many joined into testing and

finding foundation(s) for the proposed solutions 😎

REMARK:

For those who downloaded my solution before 20080201 1300 GMT

I've forgotten to remove the drop-database statements in script 00 !

:blush:

I've modified it and re-attached the zip