I read few yrs ago that Triggers are bad for performance and they're not recommanded in SQL Server (they're ok in Oracle).
Is this correct? My coworker wants to use a trigger and wants to put in a lot of logic in there. Logic like if-else. I think that should either be done in a stored proc or in code. Trigger should just be used to update/insert simple data...no?