Tuesday, April 12, 2011

Explain different isolation levels

An isolation level determines the degree of isolation of data between concurrent transactions. The default SQL Server isolation level is Read Committed. Here are the other isolation levels (in the ascending order of isolation): Read Uncommitted, Read Committed, Repeatable Read, Serializable. See SQL Server books online for an explanation of the isolation levels. Be sure to read about SET TRANSACTION ISOLATION LEVEL, which lets you customize the isolation level at the connection level.
at
Labels:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Explain the different parts that constitute ASP.NET application.

Content, program logic and configuration file constitute an ASP.NET application. Content files Content files include static text, images ...

  • Explain the different parts that constitute ASP.NET application.
    Content, program logic and configuration file constitute an ASP.NET application. Content files Content files include static text, images ...
  • Explain the advantages of ASP.NET.
    Following are the advantages of ASP.NET. Web application exists in compiled form on the server so the execution speed is faster as compar...
  • Parse Integer
    public class  Test     public Shared Sub  Main          Try              Dim  num_items  As  Integer = Integer.Parse ( "123" ) ...