Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Wayne Fillis Managing Selects and Updates in a High Transaction table RE: Managing Selects and Updates in a High Transaction table

  • March 27, 2009 at 2:57 pm

    #967756

    A question gents :

    If i place a NOLOCK for an update on a row (Update triggered by the background process) Say Transaction 1

    If there is a ROWLOCK for another update on the same row (user updates a column) Say Transaction 2

    What would happen now ?

    I do not care about dirty reads. My question is : would both the updates go through ?