WITH NOLOCK

Could WITH NOLOCK slow down select statements?

I think I can notice a considerable difference in speed since I added WITH NOLOCK to some of the select statements.
LVL 17
Tacobell777Asked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
SvenConnect With a Mentor Tech Lead Web-DevelopmentCommented:
We are using WITH NOLOCK on our servers but I never experienced a slow down when using it.
0
 
LowfatspreadConnect With a Mentor Commented:
i suppose its possible, depends how many dirty rows are in the range of the select..
0
All Courses

From novice to tech pro — start learning today.