SQL Server (TSQL) – Is it possible to EXEC statements in parallel?

by

Yes, there is a way, see Asynchronous procedure execution.

However, chances are this is not what you need. T-SQL is a data access language, and when you take into consideration transactions, locking and commit/rollback semantics is almost impossible to have a parallel job. Parallel T-SQL works for instance with requests queues, where each requests is independent and there is no correlation between jobs.

What you describe doesn’t sound at all like something that can, nor should, actually be paralellized.

More Related Contents:

  1. Convert text to system date format [duplicate]
  2. SQL where clause odd behavior [closed]
  3. How do I escape a single quote in SQL Server?
  4. Simple way to transpose columns and rows in SQL?
  5. Only inserting a row if it’s not already there
  6. Unpivot with column name
  7. Selecting data from two different servers in SQL Server
  8. Maximum size for a SQL Server Query? IN clause? Is there a Better Approach [duplicate]
  9. SQL JOIN vs IN performance?
  10. Most efficient way in SQL Server to get date from date+time?
  11. Convert varchar into datetime in SQL Server
  12. TSQL Pivot without aggregate function
  13. How to generate a range of dates in SQL Server
  14. SQL RANK() versus ROW_NUMBER()
  15. How to rewrite IS DISTINCT FROM and IS NOT DISTINCT FROM in SQL Server 20008R2?
  16. How do I delete from multiple tables using INNER JOIN in SQL server
  17. Check if a row exists, otherwise insert
  18. SQL : BETWEEN vs =
  19. Drop all the tables, stored procedures, triggers, constraints and all the dependencies in one sql statement
  20. How do I perform a GROUP BY on an aliased column in SQL Server?
  21. How do I make a composite key with SQL Server Management Studio?
  22. Script to kill all connections to a database (More than RESTRICTED_USER ROLLBACK)
  23. Alter user defined type in SQL Server
  24. Best equivalent for IsInteger in SQL Server
  25. Store multiple bit values in a single table column
  26. Syntax of for-loop in SQL Server
  27. SQL Server equivalent to MySQL enum data type?
  28. SQL – Call Stored Procedure for each record
  29. COALESCE Function in TSQL
  30. When to use EXCEPT as opposed to NOT EXISTS in Transact SQL?

Leave a Comment