Great article. As others have mentioned we are pessimistic here in SQL Serverville. We must always be very cautious of locking. I like to pass that decision on the app. Let the app get a result set to determine an update or an insert and call the appropriate code. My Database server is always more taxed than the app server, let them do something every once and a while 🙂