Twenty tips to write a good stored procedure (RB)

I came across a very useful list of tips for writing good Stored Procs by Arup Chakraborty here

I would say it can be combined with my set of best practices to include things like limiting the sets as early as possible.

Good read overall!