Article on when to use Stored Procs?

Does anybody know of some good articles or whitepapers on when to use stored
procs and when not to use them? Thanks in advance.
DaveHere is a compact artilce along with some good discussion:
http://weblogs.asp.net/rhoward/arch...1/17/38095.aspx
"Dave L" wrote:

> Does anybody know of some good articles or whitepapers on when to use stor
ed
> procs and when not to use them? Thanks in advance.
> Dave
>|||> Does anybody know of some good articles or whitepapers on when to use
> stored
> procs and when not to use them? Thanks in advance.
Thus saith the LORD GOD: "Thou shalt use stored procedures for everything,
and for everything shalt thou use them."
Seriously. Here are some:
http://weblogs.asp.net/rhoward/arch...1/17/38095.aspx
http://www.devx.com/tips/Tip/13175
http://www.csharpfriends.com/Articl...px?articleID=78
Peace & happy computing,
Mike Labosh, MCSD
"When you kill a man, you're a murderer.
Kill many, and you're a conqueror.
Kill them all and you're a god." -- Dave Mustane

are sqlclr stored procs subject to the same SQL Execution Model as other sessions?

are sqlclr stored proc sessions running in the same SQLOS execution model (Running, runnable and suspended status, Runnable Queue and Wait List) as other types of sessions and therefore ending up in the same queues, contending for very similar resources (except maybe for memory type because of MTL's role) etc?...or do they get treated in a very different way?

They are part of the execution model.

Niels