Stored Procedures - The Arguments

I'm 'pro' Stored Procedures. A couple of excellent url's that discuss the reasons...

Paul Nielson - Why use stored procedures?
Kimberley Tripp - Stored procedures are not evil...

OLTP Performance Issues

Rather useful high level summary >

http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/oltp-performance-issues.mspx