SQL Server Stored Procs not parameterized, leading to high compilations? We're experiencing about 300 SQL Compilations per second, and we use very little dynamic SQL.  However, I noticed that in SQL Profiler our calls look like:

exec cid.dbo.uspCIDLog '9425','19155852234',2 -- null

And I think they should look like this if properly parameterized:

exec cid.dbo.uspCIDLog @sFrom='9425', @sTo='19155852234', @userId=2

Will this make a difference?
It shouldn't really make a difference if the parameters are specified or if parameter location is assumed.  The compiling happens to the statements within the stored procedure.

That said, it's best practice to pass in the values properly parametrized so that if a parameter is added in the middle of the list nothing will break.