Some good points. I'd also add one slight word of warning when even doing SELECTs especially with a WHERE that doesn't use an index on the table, that can cause serious performance issues. As an aside, I like to use WITH(NOLOCK) which can increase the chance of a dirty read occuring but can improve performance