mr_effe (4/17/2014)
Yes you're right. The most locks occur by the merge statements. Do you have an idea how to prevent it?So can you also give me some hints what i have to consider when i want to update / insert in one table (with different partitions) at the same time?
Many thanks
I'm a bit out of my league here, so I asked some other experts if they can take a look at this.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP