« Notable Links | Notable Links »
Posted by David Carroll
A First Look at SQL Server 2005 Service Broker
"Many developers that set out to use a database table as a queue in their application find out that it's a lot harder than it looks. A table used as a queue has multiple processes inserting, reading, and deleting a small number of records simultaneously. This leads to concurrency issues, performance challenges, and frequent deadlocks. ... Service Broker addresses these issues by making Queues first class database objects in the SQL Server 2005 database."