I don't think one performs any faster than another. But, it is considered Best Practice to not name your Stored Procs as sp_*.
>Performance was exactly what I was worried about. If I understand it correctly it should be slightly faster for the server to execute a SP named usp_X compared to a SP named sp_X since the server doesn't first have to check if it is a system SP. (now slightly faster might only be a fraction of a fraction of a ms faster but still).
>Do you think I will gain performance (in the same way) if I name my SPs spals_X (notice it starts with sp but it doesn't start with sp_)?
>
>Just trying to squeeze out some performance :)
>
>Einar
>
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer