Daniel Hester

Microsoft Integration Architecture, Frameworks and Technologies

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

News



Archives

Post Categories

September 2012 Entries

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 ......