How much of a performance difference is it when I use Stored Procedures vs. sending the sql directly from my application?

ex sql:
select emailaddr from users where (id = " & theid & ")

I know SQL Server runs a SP and know its path but is there really that much of a difference with something this simple?

SQL server will compile the stored procedure, but I think you'd be hard pressed to see the difference in something like this. Particularly if you aren't running this many many times in succession.

SP is much faster that T-SQL but there is no sense in short & simple queries.

Always:),
Hovik Melkomian.