Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

Reg: SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED Expand / Collapse
Author
Message
Posted Monday, August 12, 2013 5:32 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Today @ 1:32 PM
Points: 973, Visits: 3,033
kevin_nikolai (8/2/2013)

SELECT
firstname
,salary
FROM dbo.employee e WITH (nolock)
JOIN salary s WITH (nolock)
ON s.employeeid = s.employeeid;

And when your colleagues get short paid because you thought it essential to put NOLOCK onto a "report" query?




The SQL Guy @ blogspot

@SeanPearceSQL

About Me
Post #1483231
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse