As much as I like this app it is still far from Twitter in getting a quick look at what is going on but locally, internationally and in sports. I fully agree that social media should not be used as main source of news.
Grattis Daniel!
Only here
Great, good to have an explanation. Guess it make sence to have FK validates against the current state and not the version store. Thanks you!
Good question. Yes, table does both have a foreign key and another table have a foreogn key on the table.Good question. Yes, table does both have a foreign key and another table have a foreogn key on the table.
Sure, what ias throwing me of is that is that the dead locks are between S locks and X locks. All Key locks by the way. Seems like MERGE is not using the version store to read the data but instead tried to take a shared lock.Sure, what ias throwing me of is that is that the dead locks are between S locks and X locks. All Key locks by the way. Seems like MERGE is not using the version store to read the data but instead tried to take a shared lock.
Not sure but asume it is a real dead lock as I get the dead lock alert inlcuding dead lock graph in Redgate SQL Monitor.Not sure but asume it is a real dead lock as I get the dead lock alert inlcuding dead lock graph in Redgate SQL Monitor.
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.
Nice seeing you at PASS. I did enjoy the monster procedure session. Hope to see you at some future conference!