Home Forums SQL Server 2008 SQL Server 2008 Performance Tuning Poor execution plan within insert trigger for UPDATE to base table having primary key on identity column as the number of inserted rows varies RE: Poor execution plan within insert trigger for UPDATE to base table having primary key on identity column as the number of inserted rows varies

  • It is too long a story. The 'need' is to not touch the application code/and or stored procedure doing the inserts. So it is left to the triggers to generate the value for the column.