Different transaction levels in sql server, DOT NET Programming

What are different transaction levels in SQL SERVER?

The Transaction Isolation level decides how is the one process isolated from theother process. Using the transaction levels you can implement locking in the SQL SERVER.

There are 4 transaction levels in SQL SERVER as shown below:-

READ COMMITTED:

In this the shared lock is held for the duration of the transaction, means that no other transactions can modify the data at the same time. The Other transactions can insert and change data in the same table, however, as long as it is not locked by the first transaction.

READ UNCOMMITTED:

In this no shared locks and no exclusive locks are honored. This is the least restrictive isolation level resulting in the best concurrency but the least data integrity.

REPEATABLE READ:

In this the setting disallows dirty and non-repeatable reads. However, even though the locks are held on read data, the new rows can still be inserted in the table, and will subsequently be interpreted by the transaction.

SERIALIZABLE:

This is the most restrictive setting holding shared locks on the range of data. ThisĀ  does not allow the insertion of new rows in the range that is locked; hence, no phantoms are allowed.

Posted Date: 9/24/2012 4:21:24 AM | Location : United States







Related Discussions:- Different transaction levels in sql server, Assignment Help, Ask Question on Different transaction levels in sql server, Get Answer, Expert's Help, Different transaction levels in sql server Discussions

Write discussion on Different transaction levels in sql server
Your posts are moderated
Related Questions
What is managed code and managed data? Managed code is code that is written to target the services of the Common Language Runtime. In order to target these services, the code m

how to replace a keyword using powershell

What is a Cloud Service? A cloud service is used to build cloud applications. This service gives the facility of using the cloud application without installing it on the comput

Design the following interface and add code to the command buttons to achieve the following using case statement. I) find coursework to be calculated using the following formula:-0

We need Long term Kentico developer needed I want a solid Kentico developer that I can rely on to handle overflow work. Usually this will include about 5 hours of work each week

What is scavenging? When server running your ASP.NET application runs low on the memory resources, items are discarded from the cache depending on cache item priority. The Cach

Explain hybrid and community cloud. The hybrid cloud having of multiple service providers. This model integrates several cloud services for Hybrid Web hosting. It is basically

SOAP Web Services A SOAP Web Service that supports three operations: add a bibliography entry, delete a bibliography entry and list all bibliography entries. You may design fo

Question: (a) Give four benefits of ASP.NET Web Controls. (b) List and explain any five properties of the ValidationSummary control. (c) Multiple Web Form controls ca

Prepare a script to automate the software "muvee Reveal" Project Description: My name is Mark, I run a company engaged in E-Learning products. We looked for a long time fo