Home Forums SQL Server 2005 SQL Server 2005 Performance Tuning Costly update trigger -70,000,000 logical reads for 30,000 rows updated! RE: Costly update trigger -70,000,000 logical reads for 30,000 rows updated!

  • February 2, 2009 at 9:50 am

    #936529

    Normally the SQL Server thinks 32 is the limit and stops execution with an error.

    See Books Online for Nested Triggers and Recursive Triggers.

    N 56°04'39.16"
    E 12°55'05.25"