Jeff Atwood wrote about this here, and while I understand the theoretical performance boost a stored procedure could offer, it does seem like a tremendous pain.
What types of queries would you see the most performance increase using stored procedures, and what types of queries would you rather just build on the fly?
Any documentation one way or another would be greatly appreciated.
See Question&Answers more detail:os