My stored procedure "best practices" checklist I present a laundry list of things I always do in stored procedures (and why).