Transaction isolation

  • Comments posted to this topic are about the item Transaction isolation

  • Thanks for easy question.

    M&M

  • 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

  • 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

  • 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

  • Good question!

  • 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

  • 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

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

  • 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.

  • 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]

  • 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

  • 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.

  • 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