Viewing 3 posts - 1 through 3 (of 3 total)
Apologies for the long delay in response. I haven't been able to further investigate this situation, though should I be able to look at it again, I will be sure...
January 16, 2012 at 12:25 am
Ninja's_RGR'us (1/5/2012)
Locking <> blocking. You removed only 1 of the factors, but not the hw.Just in case you didn't know :
http://sqlblog.com/blogs/andrew_kelly/archive/2009/04/10/how-dirty-are-your-reads.aspx
Not sure what you mean by:
You removed only 1...
January 5, 2012 at 7:47 am
Here are the actual execution plans for both versions.
I ran a
DBCC FREEPROCCACHE
DBCC DROPCLEANBUFFERS
before each run as well.
January 5, 2012 at 6:30 am
Viewing 3 posts - 1 through 3 (of 3 total)