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!
noeld
SSC Guru
Points: 96590
More actions
February 3, 2009 at 12:15 pm
#937426
They will embed the update code directly in the sprocs where the base table is itself updated.
WISE decision!
* Noel