Tuesday, March 20, 2012

Parallel execution in SQL Server

Is there any way to run a stored procedure in parallel to another one? i.e. I have a stored procedure that sends an email. I then scan a table and send any unsent emails. I do not want the second part to slow the response to the user.

Why don't make a JOB for send any unsend emails ?

Store procedure only insert a row in a buffer table and job consume the rows in that table.

Wink

|||I have tried using a Job before and it was not a nice experience - guess I will have to sort it out properly this time.

No comments:

Post a Comment