Good read.

I personally dislike the idea of using stored procedures as it mixes the data and logic. The performance gains (!?) is not good enough.