kevin_nikolai (8/2/2013)
SELECTfirstname
,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?