principlesqlMinor
Stored procedures vs inline SQL in a Job step
Viewed 0 times
storedproceduressqlstepinlinejob
Problem
I have created a job with two steps:
-
Create and email a quick report on the number of new records created in the error table that day, literally a:
...but with some happy formatting to make an email table.
Currently I have step 2 running SQL in the job step rather than calling a stored procedure.
My question is, does it make a difference (performance or otherwise) in SQL Server 2014, to run a job step that calls a stored procedure or one that executes inline SQL?
- Delete 50000 rows from an error table older than 90 days.
-
Create and email a quick report on the number of new records created in the error table that day, literally a:
SELECT count_big(*)
FROM table
WHERE datevalue DATEADD(DAY,-1,GETUTCDATE())...but with some happy formatting to make an email table.
Currently I have step 2 running SQL in the job step rather than calling a stored procedure.
My question is, does it make a difference (performance or otherwise) in SQL Server 2014, to run a job step that calls a stored procedure or one that executes inline SQL?
Solution
does it make a difference (performance or otherwise) in SQL Server 2014, to run a job step that calls a stored procedure or one that executes inline sql?
In your case, since you are just doing reporting, it won't make much difference either using inline SQL or a stored procedure.
Aaron Bertrand provides a really good answer to a related question:
Stored procedures vs. inline SQL
In your case, since you are just doing reporting, it won't make much difference either using inline SQL or a stored procedure.
Aaron Bertrand provides a really good answer to a related question:
Stored procedures vs. inline SQL
Context
StackExchange Database Administrators Q#97801, answer score: 3
Revisions (0)
No revisions yet.