Transaction isolation

  • aries27_himani

    SSC Rookie

    Points: 37

    Comments posted to this topic are about the item Transaction isolation

  • M&M

    SSC-Insane

    Points: 21679

    Thanks for easy question.

    M&M

  • Koen Verbeeck

    SSC Guru

    Points: 258911

    Easy one, thanks.

    For the moment, almost 30% took Read Commited (the default). Surprising, as Repeatable Read is stricter.

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

  • SQLRNNR

    SSC Guru

    Points: 281210

    There needs to be more questions on isolation levels.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • Koen Verbeeck

    SSC Guru

    Points: 258911

    SQLRNNR (4/19/2012)


    There needs to be more questions on isolation levels.

    Looking at the current score, certainly. 32% for Read Committed.

    If Snapshot Isolation was one of the answers, I would understand a lot of people getting it wrong, but this isn't the case.

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

  • This was removed by the editor as SPAM

  • Carlo Romagnano

    SSC-Insane

    Points: 21715

    Good question!

  • TomThomson

    SSC Guru

    Points: 104763

    Nice easy question.

    Koen Verbeeck (4/19/2012)


    SQLRNNR (4/19/2012)


    There needs to be more questions on isolation levels.

    Looking at the current score, certainly. 32% for Read Committed.

    If Snapshot Isolation was one of the answers, I would understand a lot of people getting it wrong, but this isn't the case.

    Yes, some education is needed in this area. The results aren't quite as bad now as when Koen saw them, but currently 27% opted for for READ COMMITTED (the second lowest isoaltion level) which is certainly not good. And the thing that really gets me is 2% saying Read Uncommitted!

    Tom

  • honza.mf

    SSCertifiable

    Points: 5519

    L' Eomot Inversé (4/19/2012)


    Yes, some education is needed in this area. The results aren't quite as bad now as when Koen saw them, but currently 27% opted for for READ COMMITTED (the second lowest isoaltion level) which is certainly not good. And the thing that really gets me is 2% saying Read Uncommitted!

    I understand someone who selected Read Uncommited. It's very easy to mix or overlook "most" and "least". Insufficient level of coffee can also make a problem.

    Those who selected Read Commited probably use two isolation levels. "Clean" and "Dirty". And even an idea of cleaner than clean is horrible for them.



    See, understand, learn, try, use efficient
    © Dr.Plch

  • DBA_Dom

    SSCrazy

    Points: 2792

    Great question, I just had to read up on this yesterday as part of an investigation. What timing. Thanks for the question.

  • chrisfradenburg

    SSCrazy Eights

    Points: 9592

    Read committed is down to 16% so it may just be the early people that threw it off. Read uncommitted is up to 5% though. I have wondered if there are people that throw down any old answer just to see what the right one is.

  • EL Jerry

    SSCertifiable

    Points: 6932

    Great question. I think this is an area that is not widely used so in my personal opinion we need to get more knowledge on this. I did some documents research that lead me to the correct answer, but I have not seen this feature implemented anywhere.

    "El" Jerry.

    "El" Jerry.

    "A watt of Ottawa" - Gerardo Galvan

    To better understand your help request, please follow these best practices.[/url]

  • TomThomson

    SSC Guru

    Points: 104763

    cfradenburg (4/19/2012)


    Read committed is down to 16% so it may just be the early people that threw it off. Read uncommitted is up to 5% though. I have wondered if there are people that throw down any old answer just to see what the right one is.

    There are. I've done it once or twice myself.

    Tom

  • chrisfradenburg

    SSCrazy Eights

    Points: 9592

    L' Eomot Inversé (4/19/2012)


    There are. I've done it once or twice myself.

    I'm thinking people that do it as a rule without really thinking rather than when they're not sure of the answer.

  • Paul White

    SSC Guru

    Points: 150341

    If SNAPSHOT had been one of the options, we could have had an interesting discussion over which is more strict.

    Good question anyway, thanks!

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

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