- "READUNCOMMITTED and NOLOCK cannot be specified for tables modified by insert, update, or delete operations. The SQL Server query optimizer ignores the READUNCOMMITTED and NOLOCK hints in the FROM clause that apply to the target table of an UPDATE or DELETE
How is it possible to ignore something which cannot be specified?
Why to continue having it?
Why were they permitted/introduced for DELETE and UPDATE?
What did UPDATE (DELETE) WITH(NOLOCK) mean in earlier versions of SQL Server when were they introduced?
 Table Hints (Transact-SQL)
SQL Server 2008 R2
I did not expect that the only question which was rhetorical would be answered.
Let's consider I did not ask it
View Complete Post