Very good and interesting article
Thanx.

Thanks Mr. Metcalf, every bit helps in keeping your performance in line.  Yes, we have a high proportion too. 

Question (with apologies in advance for my ignorance):

I use ADO in my app to execute the sproc. I create a command object with collection of parm objects standard (works with input and/or out parms).

When I set the CommandText I do not fully qualify the sproc name.

*This* is what the article is talking about, correct? I should set the CommandText to "dbo.spDoSomething" instead of just "spDoSomething".

The real question is: the issue is the same if using ADO and not just in T-SQL, correct? The names (or case) of the members of the parms collection does not matter, although the order does.