Send an Email at a future date
Unfortunately there is no way to do this in Gmail. If you have Outlook 2007 available create a new mail and click on … Read more
queue
Is there a queue copy program available for Windows 7?
I use TeraCopy for this. Simply a much better tool than the default copy handler for Windows. And it handles file copies sequentially … Read more
How to run commands as in a queue
Append & to the end of your command to send it to the background, and then wait on it before running the next. … Read more
How can I limit SQL Server Agent’s simultaneous jobs number?
I’m looking for a setting (other than schedules shifting) which could limit the number of jobs running simultaneously. I have 844 jobs in … Read more
Why is our query suddenly returning rows it should not (using READPAST and UPDLOCK options)?
We have a job table that looks like this CREATE TABLE [dbo].[Clearing]( [Skey] [decimal](19, 0) IDENTITY(1,1) NOT NULL, [BsAcctId] [int] NULL, [Status] [varchar](20) … Read more
Using a Table as a Queue without sp_getapplock/sp_releaseapplock
I have a list of commands I need to execute, all of which are contained within a table I’ve named myQueue. This table … Read more
No service broker active on database
I am trying to set up query notification however when I try to create a queue and service I get the error ‘There … Read more
Recommendations on how to organize Queues in Service Broker
I have a service broker application that currently has 5 or 6 queues on two servers. The general workflow is: Server A User … Read more
Best way to implement concurrent table based queue
I have a table in MySQL that represents a queue of links to be processed. The links are processed by an external app, … Read more
FIFO queue table for multiple workers in SQL Server
I was attempting to answer the following stackoverflow question: What SQL Server 2005/2008 locking approach should I use to process individual table rows … Read more
