Will a stored procedure run faster as a Job under Sql Agent then it will in QA run on the server?
From my understanding, if you schedule anything as a job then it excuted on the server side. However, a PROC is a server side cache the execution plan for re-use so if you run from QA or as a job, it should have the same peformance due to the fact it still run on the server. Is this true? thanks...