SQL Server Stored Procs not parameterized, leading to high compilations?
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.