Comments by andyharman (Top 1 by date)

I just checked with my production DBA colleague. He says that if you are running this on a server that has lots of CPUs then you should consider using the "maxdop = 1" hint when you do sub-queries in this way. If SQL-Server decides to split this single query over multiple processors then it is technically possible for the processes to lock each other.