Geeks With Blogs
Daniel Hester Microsoft Integration Architecture, Frameworks and Technologies September 2012 Entries
SQL Server Table Polling by Multiple Subscribers
Background Designing Stored Procedures that are safe for multiple subscribers (to call simultaneously) can be challenging. For example let’s say that you want multiple worker processes to poll a shared work queue that’s encapsulated as a SQL Table. This is a common scenario and through experience you’ll find that you want to use Table Hints to prevent unwanted locking when performing simultaneous queries on the same table. There are three table hints to consider: NOLOCK, READPAST and UPDLOCK. Both ......

Posted On Wednesday, September 5, 2012 3:09 PM

Copyright © Daniel Hester | Powered by: