@kalman --- that wont get round the contention, if you use the method shown in the article you can throttle the deletes to avoid locking for too long...
Still nailing down best fit on t-sql, but if you dont need any additional info from the 2nd table why join especially if not one to one? Surely just checking...
@Kalman --- that wont get round the contention, if you use the method shown in the article you can throttle the deletes to avoid locking for too long...