What are isolation levels and use of isolation levels?
While executing queries, SQL Server often required to acquire locks on resources to prevent dirty reads,phantom reads etc. These locking behavior will be depends on isolation levels. Based on isolation level of transaction, SQL Server will acquire locks on resources.
There are different isolation levels
SQL Server Interview Questions · · · ·