CODEWITHSUNDEEP
sql-serversql-server-2008
Sameer
Sameer

Reputation: 3173

What are the consequences of using IsolationLevel.ReadUncommitted for inserts?

I have always understood isolation levels in context of read operations because all the books and articles i read always explained isolation levels in the read context.

I am trying to understand IsolationLevel and its implication for inserts.

Thanks.

Upvotes: 0

Views: 263

Answers (1)

Alessandro Alpi
Alessandro Alpi

Reputation: 378

since you're inserting data, and an exclusive lock is always needed, the read uncommitted isolation level does not affect this kind of statement.

As you may already know, the processes that try to read from the resource on which you're inserting, if they're under the read uncommitted isolation level, can read the uncommitted version of the record. Additionally, if a page-split occurs, duplicate rows can be displayed.

However, you can read also this good post about the read uncommitted isolation level on reading scenario: Why use a READ UNCOMMITTED isolation level?

Upvotes: 1

Related Questions