Monday, February 20, 2012

Positive/Negative with ROWLOCK

When you want to use a ROWLOCK?
When you not want to user a ROWLOCK?
Thank You,Very rarely!
I've used that hint only twice, temporarily when diagnosing deadlocks. I
eventually removed it in both cases.
Adam Machanic
Pro SQL Server 2005, available now
http://www.apress.com/book/bookDisplay.html?bID=457
--
"Joe K." <Joe K.@.discussions.microsoft.com> wrote in message
news:DDD23068-06F5-4103-A85D-98CC2452A065@.microsoft.com...
> When you want to use a ROWLOCK?
> When you not want to user a ROWLOCK?
> Thank You,

No comments:

Post a Comment