Browse by Tags

Tagged Content List
  • Blog Post: Using READPAST with Order By clause in SQL Server with and without Index

    Folks, I recently ran into this and decided to share this with the larger community... If you wanted to do a READPAST on the table but have on 'Order By' in your SQL query, it somehow does not return any row if there is an existing lock on a row (although it still prevents you from doing dirty reads...
  • Blog Post: Simple example of using BizTalk Business Rules Engine (BRE) with Database

    Folks, I was recently building a proof of a rules based BizTalk Application for a customer where the specific requirement was to be able to change the rules in a simplistic way so that Business Users could update the rules without having to go through the gory details of undeploy, version, publish &...
  • Blog Post: Timestamp data type in SQL Server

    Just looking at the timestamp data type, I realized that in SQL Server this exposes an automatically generated unique binary number (basically to help in version-stamping the rows). The timestamp data type is just an incrementing number and has nothing to do with preserving a date or a time. To actually...
Page 1 of 1 (3 items)