Microsoft interview question

Write a complete SQL trigger and discuss whether it is optimized.