Transaction Isolation level



Few important things about isolation level

Read uncommitted

When its used, SQL Server not issue shared locks while reading data. So, you can read an uncommitted transaction that might get rolled back later. This isolation level is also called dirty read. This is the lowest isolation level. It ensures only that a physically corrupt data will not be read.

Read committed

This is the default isolation level in SQL Server. When its used, SQL Server will use shared locks while reading data. It ensures that a physically corrupt data will notbe read and will never read data that another application has changed and not yet committed,but it does not ensure that the data will not be changed before the end of the transaction.

Repeatable read

When its used, the dirty reads and nonrepeatable reads cannot occur. It means that locks will be placed on all data that is used in a query, and another transactions cannot update the data.

Nonrepeatable read

When a transaction reads the same row more than one time, and between the two (or more) reads, a separate transaction modifies that row. Because the row was modified between reads within the same transaction, each read
produces different values, which introduces inconsistency.

Comments

Post a Comment

Popular posts from this blog

Delete Confirmation for Delete ButtonField, TemplateField and CommandField in a GridView in ASP.NET

Introduction: This article explains how to add delete confirmation for ButtonField, CommandField and TemplateField columns in a GridView. In this example, I am using a GridView and delete buttons to just hide the row to keep the demo simple. Markup: < html   xmlns = "http://www.w3.org/1999/xhtml" > < head   runat = "server" >      < title ></ title > </ head > < body >      < form   id = "form1"   runat = "server" >      < asp : GridView   ID = "GridView1"   runat = "server"   Font-Names = "Tahoma"   Font-Size = "Small"          CellPadding = "4"   BorderColor = "#507CD1"   BorderStyle = "Solid"   AutoGenerateColumns = "false"          ForeColor = "#333333"   GridLines = "None"   OnRowDataBound = "GridView1_RowDataBou...
Read more

Selecting/Deselecting all CheckBoxes inside a ListView In ASP.NET

Introduction: This articles shows how to toggle checkboxes selection in a ListView using Javascript. Example in this article shows a ListView populated with random records with SelectAll functionality Background:   Often we are required to make one or multiple selection when different options are presented in a databound control such as GridView, Repeater, ListView so on. It is cumbersome to deselect each item individually when the selection has to be cleared. ListView Header can contain a checkbox to select/deselect items in all items of the ListView. Markup:    < html   xmlns = "http://www.w3.org/1999/xhtml" > < head   id = "Head1"   runat = "server" >      < title ></ title >      < script   type = "text/javascript" >          function  toggleCheckBoxes(source) {       ...
Read more

Remove Duplicate Chars From String

Remove Duplicate Chars From String CREATE FUNCTION dbo.REMOVE_DUPLICATE_INSTR ( @datalen_tocheck INT , @string VARCHAR ( 255 )) RETURNS VARCHAR ( 255 ) AS BEGIN DECLARE @str VARCHAR ( 255 ) DECLARE @count INT DECLARE @start INT DECLARE @result VARCHAR ( 255 ) DECLARE @end INT SET @start = 1 SET @end = @datalen_tocheck SET @count = @datalen_tocheck SET @str = @string WHILE ( @count <= 255 ) BEGIN IF ( @result IS NULL) BEGIN SET @result = '' END SET @result = @result + SUBSTRING ( @str , @start , @end ) SET @str = REPLACE ( @str , SUBSTRING ( @str , @start , @end ), '' ) SET @count = @count + @datalen_tocheck END RETURN @result END GO Usage: SET CONCAT_NULL_YIELDS_NULL OFF SELECT dbo.Remove_duplicate_instr (< CHAR length OF a duplicate SUBSTRING >,< string contain duplicate >) Example: To keep char set in a string unique and remove duplicate 3 char long string run this UDF as inline function. SET CONCAT_NULL...
Read more