Even your simple select/update/delete statements should be stored procedures because then they'll be compiled and you'll avoid the overhead of query plan calculation on each call.

Or so I've been told. :-/