Post reply

Isolation Levels

  • November 20, 2012 at 9:59 pm

    #284989

    Comments posted to this topic are about the item Isolation Levels

  • November 20, 2012 at 10:01 pm

    #1561083

    Always nice to brush up on the basic concepts of sql:)

  • November 20, 2012 at 10:55 pm

    #1561086

    Nice question, thanks.

    Explanation didn' mention snapshot though.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • November 20, 2012 at 11:03 pm

    #1561088

    nice question...

    ~ demonfox
    ___________________________________________________________________
    Wondering what I would do next , when I am done with this one :ermm:

  • November 21, 2012 at 1:57 am

    #1561130

    nice 🙂

    (..actually came to know these levels 6 years ago, I used (NOLOCK) in the select statements on DWH queries and was wondering rather than typing nolock for each table join.. is there any simple open/close of nolock for all the tables in that query? and thats where I came to know the isolation levels and started to use the read uncommited and read committed when needed, apart from these two I have not used any other level.)

    ww; Raghu
    --
    The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.

  • November 21, 2012 at 2:18 am

    #1561137

    Thanks for the question

    -------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
    There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
    I would never join a club that would allow me as a member - Groucho Marx

  • November 21, 2012 at 2:53 am

    This was removed by the editor as SPAM

  • November 21, 2012 at 3:03 am

    #1561152

    I loved this question so much I wanna hug you... *ahem*

    Best regards,

    Andre Guerreiro Neto

    Database Analyst
    http://www.softplan.com.br
    MCITPx1/MCTSx2/MCSE/MCSA

  • November 21, 2012 at 3:29 am

    #1561164

    Nice question, thanks!

  • November 21, 2012 at 4:16 am

    #1561180

    Very good question. I am surprised that more than 60% got this wrong!

    Sujeet Singh

  • November 21, 2012 at 5:35 am

    #1561208

    This is certainly a good example of a totally unambiguous question as far as I can see - I am surprised at only 34% right so far.

  • November 21, 2012 at 5:39 am

    #1561213

    Nice back to basics question.

    Unfortunately, knowing what the isolation levels are has never seemed to make people understand when to use which of them. Using read committed when what is needed is repeated read or serializable is the most common error, but using red uncommitted when it's totally inappropriate is almost as common. Also, most people seem to think that snapshot implies serializable, although it clearly doesn't.. Perhaps because they think that snapshot is a version of "optimistic locking" and know that there is a way of delivering serializable and think that that means everything which might be described as optimistic locking delivers serializable. In fact the MS snapshot isolation level is somewhere in between ISO repeatable read and ISO serializable, not the same as either or them. Maybe the fact that read committed snapshot is not a separate isolation level, but a mechanism for providing read committed isolation makes people think snapshot is just a mschanism too, not a separate isolation level.

    Incidentally, I find it slightly disappointing that MS haven't provided an optimistic locking mechanism to provide serializable isolation, although how to do this has been known for a couple of decades or more; maybe they've found it doesn't enough performance over the current serializable method to be worth doing.

    Tom

  • November 21, 2012 at 5:45 am

    #1561215

    A nice explanation to the Locking and Isolation Level article can be viewed at :-

    http://www.sqllion.com/2009/07/transaction-isolation-levels-in-sql-server/

  • November 21, 2012 at 7:06 am

    #1561238

    Can someone explain in what way SNAPSHOT doesn't meet the stated requirements? That's the answer I selected and I always like to know exactly how I've been a helpless newb... 😛

  • November 21, 2012 at 7:08 am

    #1561241

    Thanks for the great question and thanks Tom for the explanation.


    Everything is awesome!

Viewing 15 posts - 1 through 15 (of 23 total)

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