Using a database table as a queue
I’d use an IDENTITY field as the primary key to provide the uniquely incrementing ID for each queued item, and stick a clustered index on it. This would represent the order in which the items were queued. To keep the items in the queue table while you process them, you’d need a “status” field to … Read more