Different lock modes

  • How is the exclusive lock mode different from the update lock mode if a record is being updated? I understand each mode can apply to an update.

  • Update locks are compatible with shared locks, exclusive are not. An update first takes update locks on all of the rows it need to update and then, once it has all of the rows locked with an update lock, converts that lock to exclusive so that the change can be made.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply