|
|
|
|
|
Total Hits: 53 | Today: 0
|
Author: Oleg Vorkunov a.k.a. Alan Kaplan
|
Rating:
|
|
Quite often SQL Server developers need to execute long running sqls such as updates, inserts, bulk inserts, index creation, and other non-query type of T-SQL. At the end total execution time will be a sum of each sql’s execution time. With such powerful multi-processors SQL servers developers do not utilize that power. This is where multi-tasking comes in place. SQL Server 2005 and up provided Database developers with one of the tools to execute sql asynchronously- that tool call Service Broker. It has it purpose, but sometimes it does not solve the problem.
|
|
|
|
Latest Posts at Dev Forums
|
|
|
|
|
|
|
|
|
|
|
