Forum Replies Created

Viewing 2 posts - 1 through 2 (of 2 total)

  • RE: Deleting Large Number of Records

    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 ....

  • RE: Deleting Large Number of Records

    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

Viewing 2 posts - 1 through 2 (of 2 total)