New answers tagged

0

Based on docs, SQL Server does not allow statements that are waiting for locks to be blocked by newer lock requests. SQL Server PDW (synampse after all) has not fully implemented this process. In SQL Server PDW, continuous requests for new shared locks can sometimes block a previous (but waiting) request for an exclusive lock. For example, an UPDATE ...


4

Finally, we have just made a breakthrough with our issue. Thanks Erik Darling for a hint. First, I will try to clarify a bit the entire application process to give you the context. There is a quite complex application code running as a single database transaction. It uses several different User-Defined Table Types as table variables. Some of the types are ...


Top 50 recent answers are included