Reg: SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » T-SQL (SS2K5) » Reg: SET TRANSACTION ISOLATION LEVEL READ...

Reg: SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED

Rate Topic

Display Mode

Topic Options

Author

Message

nagesh.prasad

Posted Monday, December 31, 2012 12:25 AM

Grasshopper

Group: General Forum Members
Last Login: Friday, June 14, 2013 4:17 AM
Points: 19, Visits: 33

Hi,

I am new to this DB Development.

Please advice, why we need this "SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;" while creating SPs.

Regards,
Nagesh Prasad

Post #1401298

GilaMonster

Posted Monday, December 31, 2012 1:52 AM

SSC-Dedicated

Group: General Forum Members
Last Login: Today @ 1:52 AM
Points: 38,104, Visits: 30,395

You don't need it and frankly you probably shouldn't be using readuncommitted without a very good reason.

See - http://blogs.msdn.com/b/davidlean/archive/2009/04/06/sql-server-nolock-hint-other-poor-ideas.aspx
(nolock is much the same as read uncommitted, just one's a hint)

Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1401313

« Prev Topic | Next Topic »

Permissions