NoLock VS ReadUncommitted Hints

NoLock and ReadUncommitted both are same. Both of it will leads to bad data being returned …!!!

Mostly, we are able to see ‘WITH (NOLOCK)’ next to table name,only to avoid the deadlock in SQL and result the query fast.
Suppose, if we have 20 tables in the query, each …

Isolation level-ReadUnCommitted: Pictorial Representation -Phase#2

Here is the pictorial representation to show , how the dirty read occurs in the system. This is mainly occurs when we set the Isolation level from Read Committed to Read UnCommitted(NoLock). There is no difference between Nolock and Read UnCommitted in SQL Server.

Before reading this, you must …

Page 2 of 712345...Last »