Fast query, but slow from Stored Procedure / Function- How query optimizer can screw your day
How parameter sniffing can destroy your query performance
sql
Setting Firing Order Of SQL Triggers
At times there is a need to control order of execution of triggers. This could be due to business requirement but also as a way to control history of a record I usually don’ t see people put any way to prevent trigger nesting, example update trigger updating same records would fire the trigger again.