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

Strange Behavior with (nolock) Expand / Collapse
Author
Message
Posted Tuesday, October 22, 2013 3:32 PM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Yesterday @ 9:40 AM
Points: 3,135, Visits: 11,477
I suggest running this to see the count with and without the NOLOCK to see if it is even related to the NOLOCK hint:

declare @st datetime;

set @st = getdate()
SELECT count(*) FROM dbo.Product with (nolock);
select Elapsed_Milliseconds = datediff(ms,@st,getdate())

set @st = getdate()
SELECT count(*) FROM dbo.Product;
select Elapsed_Milliseconds = datediff(ms,@st,getdate())


Post #1507393
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse