Post reply

Transactions 3

  • May 29, 2012 at 8:23 pm

    #257224

    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]

  • May 29, 2012 at 10:33 pm

    #1494446

    Nice & easy question...

    Thanks

  • May 29, 2012 at 10:50 pm

    #1494450

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

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

    Follow me on
    Twitter: @sqltwins

  • May 29, 2012 at 10:51 pm

    #1494451

    Good one. Got this right this time 🙂

    M&M

  • May 29, 2012 at 11:00 pm

    #1494454

    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.

  • May 30, 2012 at 1:56 am

    This was removed by the editor as SPAM

  • May 30, 2012 at 2:05 am

    #1494482

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

  • May 30, 2012 at 2:56 am

    #1494501

    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

  • May 30, 2012 at 4:10 am

    #1494538

    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!

  • May 30, 2012 at 5:09 am

    #1494569

    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

  • May 30, 2012 at 5:21 am

    #1494574

    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]

  • May 30, 2012 at 5:35 am

    #1494582

    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

  • May 30, 2012 at 5:52 am

    #1494590

    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

  • May 30, 2012 at 5:55 am

    #1494592

    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

  • May 30, 2012 at 6:02 am

    #1494595

    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