http://www.sqlservercentral.com/Content tagged T-SQL, Performance Tuning and Scaling, Miscellaneous, Strategies posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)As Chris points out, in most applications these days you end up having to go with optimistic locking, which presents a few challenges. Chris works through the list of options. If you're building web/disconnected apps and need anything besides last update wins, this one is for you. http://www.sqlservercentral.com/articles/Performance+Tuning+and+Scaling/dealingwithchangingdata/1233/2003/12/19http://www.sqlservercentral.com/articles/Performance+Tuning+and+Scaling/dealingwithchangingdata/1233/