Daniel Hester

Microsoft Integration Architecture, Frameworks and Technologies

  Home  |   Contact  |   Syndication    |   Login
  8 Posts | 0 Stories | 2 Comments | 0 Trackbacks




Concurrency and Thread Safety
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 ......