Post reply

how to decide which isolation is better while implement scripts in sql server

  • September 5, 2018 at 12:42 am

    #376913

    Hi I have one doubt in sql server .

    how to choose which isolation level is better while implement sql script.

    in sql server we have isolation level are multiple 1)read committed
    2)read uncommitted)repeatable read 4)serialzable.

    can you please tell me which situation which isolation is better and how to take decision
    which isolation is better while write scripts in sql server .

  • September 5, 2018 at 12:14 pm

    #2004567

    That depends on what the scripts are doing. If you are altering an object I would say serializable, however, for DDL, your script will wait for a current query to finish if there is one running against the object

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

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