DaveWentzel.com            All Things Data

Queue Processing Using SQL Server


you can google to get specifics of how this works...this is just my list of best practices. 
  • Use UPDLOCK on the SELECT that will read the q to begin processing. 
  • It is best to also use READPAST on this SELECT ...so WITH (UPDLOCK, READPAST).  This will allow additional processing spids to not block while previous rows are being processed. 

Data Modeling

SQL Server Home