A good tip from:
Another thing you should look at from a performance standpoint is to check @ right at the beginning of the trigger. If the value is 0, that means no rows were affected by the triggering statement and executing the rest of the trigger code is unnecessary. (You should do this in any trigger.)