Transactions 3

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

  • Nice & easy question...

    Thanks

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

    Thanks & Regards,
    Nakul Vachhrajani.
    http://nakulvachhrajani.com

    Follow me on
    Twitter: @sqltwins

  • Good one. Got this right this time 🙂

    M&M

  • 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

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

  • 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

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

  • 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

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

  • 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

  • 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

  • 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

  • Thanks Ron, easy one but worth remembering.

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

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