In My last post, we learned how to use the SQL server paging effectively in real word application. This post is another SQL Server tip to implement simultaneous data queue processing in SQL Server. In many of our enterprise applications, we have the design to handle incoming request comes from the multiple sources by putting into queue (MSMQ or SQL Server table) and process it later by processing engine.
This article explains about how to process the stored requests from SQL table by mutiple engine simultaneously running in app farm. We need an way to process those requests by multiple engine simultaneously but if one engine is picked the request, other engine should not be picking it and at the same time, table should not be locked for reading other records.