Post reply

need help in clarifying doubt locks on table

  • July 3, 2018 at 11:54 am

    #357177

    Hi all,
      Can someone help me in making me understand on:
    1. how sql server put lock on table(s) and what type of lock it puts on table  when insert or update or delete happens ? i am really confused and dont know how lock works interally and how to check what lock on what table.

     2. I want to know in depth  about 5 transaction isolation level. And how locking changes according to transaction .? I tried to study from Microsoft site but i couldn't get simple n  clear view.

    3. why sql  server's default  isolation level is "read committed" when it allows phantom read ? then what transaction could be the best for bank application ?

    can someone help with good link or book  with some examples for my above doubts . thanks in advance

  • July 3, 2018 at 1:33 pm

    #1996219

    This helped me a lot to better understand locking in SQL Server. Maybe it can solve some of your questions.
    Locking in Microsoft SQL Server (Table of Content) | About Sql Server

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

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

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