Wednesday, March 7, 2012

Nolock

Will nolock on queries on the concerning tables will reduce blocking in DB ?
Assumption- I am ready to do dirty reads as I am just checking counts.It can, yes -- it will keep writes from blocking reads, but not writes from
blocking other writes, which can be an issue as well in some cases.
Adam Machanic
Pro SQL Server 2005, available now
http://www.apress.com/book/bookDisplay.html?bID=457
--
"Rect" <Rect@.discussions.microsoft.com> wrote in message
news:5B762CA5-55B8-4F66-988E-1DCA6D71EA0F@.microsoft.com...
> Will nolock on queries on the concerning tables will reduce blocking in DB
> ?
> Assumption- I am ready to do dirty reads as I am just checking counts.

No comments:

Post a Comment