Viewing 2 posts - 1 through 2 (of 2 total)
I guess you could look at setting trace flags (1211 springs to mind) to prevent lock escalation happening at all?
But that could create another problem with insufficient memory ....
September 16, 2009 at 3:31 am
#1054315
Lynn ... great article!
Any thoughts on how (or even if) this approach should be modified for bulk deletions on a SQL 2005 mirror configuration with log-shipping in place?
JC
September 15, 2009 at 7:57 am
#1053783