Looking for best practices and insight for SQL triggers.
1. Even though I have 1 record inserts, updates should I write multiple record queries and why?
2. During a trigger which has quite a bit of different inserts and things going on is it better to write a store procedure to be called from the trigger to handle this vs the trigger directly handling this and why?
Any other performance recommendations?
