Question : I have a list of commands I need to execute, all of which are contained within a table […]
Tag: queue
Retrieve next queue item
Question : I have a simple table in SQL Server 2012 which implements a processing queue. As data has been […]
Recommendations on how to organize Queues in Service Broker
Question : I have a service broker application that currently has 5 or 6 queues on two servers. The general […]
Correct way to continuously receive from a queue
Question : I have to receive messages from a queue continuously. My current code looks like this: DECLARE @status INT=1 […]
How can I limit SQL Server Agent’s simultaneous jobs number?
Question : I’m looking for a setting (other than schedules shifting) which could limit the number of jobs running simultaneously. […]
Postgres UPDATE … LIMIT 1
Question : I have a Postgres database which contains details on clusters of servers, such as server status (‘active’, ‘standby’ […]
Row inserted to DB in main app is not available in the different process. Can MySQL defer some queries?
Question : I have such problem. My main app process some request and insert the new row into DB, then […]
Postgres Listen/Notify As Message Queue
Question : Is there any way to use Postgres Listen/Notify feature to deliver a message to a channel and have […]
Best way to implement concurrent table based queue
Question : I have a table in MySQL that represents a queue of links to be processed. The links are […]
FIFO queue table for multiple workers in SQL Server
Question : I was attempting to answer the following stackoverflow question: What SQL Server 2005/2008 locking approach should I use […]
- 1
- 2