Post reply

SET .....

  • May 10, 2002 at 1:53 pm

    #158561

    SET TRANSACTION ISOLATION LEVEL SERIALIZABLE

    When should this be used ?

    Benefits ?

    Costs ?

  • May 10, 2002 at 2:19 pm

    #428909

    1) Use when you want to make sure no other process is touching the data you are working with.

    2) You have set all your queries during the session to work as though you have supplied the HOLDLOCK hint in them to block other users access to the records you are working with.

    3) The locks will slow down other user because it does not allow them access while the records are in use thus delaying the time it takes for transactions to complete.

    See "SET TRANSACTION ISOLATION LEVEL" in BOL for more information.

    "Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

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

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