Please read Jeff Moden's comments on pg 5 of this thread. Seems there is a difference of opinion on where in, exists and inner join. I will recode using...

Thanks for the comments Ole. I use maxdop because this process has to run secondary to production jobs and I do that by limiting its processes. This job...

Please see Jeff Moden's comments on page 5 concerning where in, exists and inner join, interesting reading. In practice most of the elapsed time is on building the outer...

Thanks for the comments it has been interesting reading them. As to the dangers of nolock perhaps I should have added (if the editor would allow) that in this...

Chris - I like the approach of testing and sharing the findings, thanks. I'll modify the code in the article and publish the findings between where in, exists and...

Nice feature to delete and archive in one step, thanks. In this article no need to archive as these are obsolete rows.

Thanks for the comments it has been a learning experience to see there is such a vibrant tech community. I am using the technique in a 7*24 shop with...