Hacker News new | ask | show | jobs
by RaftPeople 14 days ago
> I recently encountered a query that deadlocked on itself because it used a parallel execution plan and updated multiple indexes in a manner that the different threads could conflict with each other.

MS SQL?

We've had to set MAXDOP 1 on some specific queries for a long time.