One question I've always had on this topic is: Is there a chance of an execution plan being cached which works well for the insert but then creates problems...