Craig,
>>More control of the details and better scalability under load. Any others?
>
>Those aren't enough?
Just didn't want to miss anything. Those were what came to mind from the Remote View analogy.
>I don't think we can make a blanket statement that it's just for heavily-loaded systems. The design and implementation of the system needs to be looked at, as does the infrastructure. There are also political things to take into consideration. DBAs typically like things to run through an SP.
Understood.