P
Peter Åkerlund
@djpakerlund.bsky.social
Database professional, Sci-Fi fan and over all skeptic!
34 followers141 following35 posts
I did already find you block and seems to be similar but as you say without the RCSI part. There are some temporary table DDL included as the merge are between the temp table and the target table. The target table do have one non-clustered index but the dead lock is on the PK index.I did already find you block and seems to be similar but as you say without the RCSI part. There are some temporary table DDL included as the merge are between the temp table and the target table. The target table do have one non-clustered index but the dead lock is on the PK index.
P
Peter Åkerlund
@djpakerlund.bsky.social
Database professional, Sci-Fi fan and over all skeptic!
34 followers141 following35 posts