Transactions 3

  • Ron McCullough

    SSC Guru

    Points: 63877

    Comments posted to this topic are about the item Transactions 3

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • Hardy21

    SSCrazy Eights

    Points: 9708

    Nice & easy question...

    Thanks

  • Nakul Vachhrajani

    SSChampion

    Points: 10225

    Nice & easy question. Brings back memories from a couple of days ago 🙂

    Thanks & Regards,
    Nakul Vachhrajani.
    http://nakulvachhrajani.com
    Be courteous. Drive responsibly.

    Follow me on
    Twitter: @sqltwins

  • M&M

    SSC-Insane

    Points: 21699

    Good one. Got this right this time 🙂

    M&M

  • davoscollective

    SSCertifiable

    Points: 6355

    Is this not the same question that we've had three times now?

    Maybe the addition of set XACT_ABORT OFF

    But it's off by default, right?

    I guess it reinforces how transactions work in MSSQL so it's a good thing.

  • This was removed by the editor as SPAM

  • Toreador

    SSChampion

    Points: 11261

    Presumably the 21% who answered "0" didn't read the discussions following the previous question 🙂

  • TomThomson

    SSC Guru

    Points: 104773

    Until I saw the counts of answers so far I thought that maybe this repetition with tiny variations (this is the third version of this question in a couple of weeks) was a bit much, but then I saw that 29% (77 out of 270) so far have got this wrong, so now I reckon the repetition is useful after all.

    Tom

  • call.copse

    SSCoach

    Points: 17242

    Well, I think I'll remember this one now anyhow! I did have to check the ON / OFF status and which meant what, as Microsoft do not always seem to agree with my mental logic on binary switches and how they are named. They did this time!

  • Koen Verbeeck

    SSC Guru

    Points: 258985

    Another great question Ron. It certainly useful to refreshen the transaction theory from time to time.

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

  • Ron McCullough

    SSC Guru

    Points: 63877

    L' Eomot Inversé (5/30/2012)


    Until I saw the counts of answers so far I thought that maybe this repetition with tiny variations (this is the third version of this question in a couple of weeks) was a bit much, but then I saw that 29% (77 out of 270) so far have got this wrong, so now I reckon the repetition is useful after all.

    Agreed it is somewhat of a repeat (with a slight, ever so slight variation), but going back to those prior questions on May 16th and 23rd) my last look at those answers:

    a. 16th 53% correct

    b. 23rd 47% correct

    Seems like there is still a great deal of learning that needs to be driven home.

    Now fore warned is fore armed, be prepared, the last in the series is scheduled for June 8th. If that is not answered 100% correctly, I guess I'll give up, no sense flogging a dead horse.

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • Bryant McClellan

    SSCarpal Tunnel

    Points: 4284

    The repetition is a good idea but really depends on the audience. In high school Honors Calculus we has one basic proof show up on EVERY weekly quiz until everyone got it right. The rationale was that the proof was so basic to calculus in general that if you didn't get it, you were doomed. Eventually everyone got it right. I managed to get it from the first attempt onward although, for the life of me, I cannot remember that proof now.

    Point being that transaction control is so basic to developing robust transactional systems that a little repetition early can save some serious data headaches later.

    ------------
    Buy the ticket, take the ride. -- Hunter S. Thompson

  • Thomas Abraham

    SSChampion

    Points: 10761

    Just from the first 2 lines of code, I knew this was a bitbucket question. 🙂

    Thanks for the easy (now that I've researched the topic) point.

    I doubt I will be missed, not being a major contributor here. But, I want to wish you all well, as I'll be on vacation for a few weeks. (My wife thinks the purpose of our trip is to revive the Greek economy. She'll try.)

    ??t??, ?a? ?a?? t??? µe t? ??t?µa t?? ?µ??a?.

    (Goodbye, and good luck with the question of the day. Either that, or I just ordered 2 ouzos and a squid.)

    Edited to correct spelling of "question" - "quest" made it by spell check. Maybe I'll try German instead.

    [font="Verdana"]Please don't go. The drones need you. They look up to you.[/font]
    Connect to me on LinkedIn

  • Koen Verbeeck

    SSC Guru

    Points: 258985

    Thomas, have fun on your vacation!

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

  • Sherwin Anderson

    SSCrazy

    Points: 2883

    Thanks Ron, easy one but worth remembering.

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

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