Viewing 7 posts - 1 through 7 (of 7 total)
You're correct about the latch contention...
March 18, 2018 at 8:02 pm
Sean Lange (8/10/2016)
August 10, 2016 at 2:11 pm
Sean Lange (8/10/2016)
Ncage (8/10/2016)
Steve Jones - SSC Editor (8/10/2016)
I'd...
August 10, 2016 at 1:02 pm
Steve Jones - SSC Editor (8/10/2016)
I'd think that the...
August 10, 2016 at 12:13 pm
Thanks everyone for all the help. That was definitely the problem (untrusted) in our database. The script generator was just putting the database to the state that it was in....
August 19, 2014 at 12:03 pm
GilaMonster (7/9/2014)
Fragmentation is not that massive of a concern, but rebuilding indexes also removes the half-full pages that you tend to get as a result of page...
July 9, 2014 at 8:07 am
Thanks guys for the clarification. I got confused with another problem that was happening. You are in fact correct (i tested it). NOLOCK/READ Uncommited will still work with snapshot isolation...
January 14, 2014 at 7:24 am
Viewing 7 posts - 1 through 7 (of 7 total)