Walter, check out
http://weblogs.asp.net/fbouma/archive/2006/05/26/Yay_2100_-A-new-Stored-Proc-vs.-Dyn.-Sql-battle_2100_.aspxand
http://discuss.joelonsoftware.com/default.asp?design.4.433180.44I think anybody who has seen any of this realizes that "SP is best" or even "SP is a good place to start" is shaky - "premature optimization" is how I think it was described in one of the online articles I read a year or two ago. Now that MS is about to push in-memory processing in its various Linq permutations, I think people will swing into line and maybe even assert that they are prophets who said it all along. ;-)
"... They ne'er cared for us
yet: suffer us to famish, and their store-houses
crammed with grain; make edicts for usury, to
support usurers; repeal daily any wholesome act
established against the rich, and provide more
piercing statutes daily, to chain up and restrain
the poor. If the wars eat us not up, they will; and
there's all the love they bear us."
-- Shakespeare: Coriolanus, Act 1, scene 1