Session Details -
Multi threading in SQL
|
|
Batch processin is very costly in terms of contention. To get you batch processes run before the boss comes in the next day you need to do stuff in parallel.
Service broker enables you to have your batch process work in parallel, and too boot it's transactional, which means if everything falls over you can easily restart.
|
|
|
Simon Sabin
|
|
|
|
Simon is an independent Database consultant specialising in the world of search, distributed architectures, business intelligence and application development. He has worked with SQL Server since 1998 and has always focused on high performance reliable systems. He was awarded as an MVP in 2006 and is regular speaker at SQL Server events as well as writing for SQLServerCentral and Simple-Talk.com.
|