Run T-SQL in parallel agents jobs and wait till all the jobs are done
The following script extends the work of John Huang and his excellent blog post about parallel SQL Execution using the SQL Agent: http://www.sqlnotes.info/2012/01/04/parallel-task-scheduling-1-jobs/ The extension is a wrapper to obfuscate the logic to wait for all the jobs to be done. This approach can significantly improve the duration of large database operations. E.g you can