Post reply

Transactions

  • September 25, 2012 at 8:28 am

    #1541899

    i TOTALLY AGREE WITH YOUR POINT HERE.

  • September 25, 2012 at 8:31 am

    #1541902

    Hugo Kornelis (9/25/2012)

    A good question; thanks!

    However, I did find myself staring at the wording for a bit before answering - and hoping that my interpretation was the correct one. The term "failing" can be ambiguous. Some people might argue that "failing" also includes running without error but not rolling back changes on a rollback. And I even considered the possibility that the question was phrased by a non-native speaker who intended to ask which code fragments would have a permanent effect (e.g. the rollback would not affect the DDL statement).

    Maybe a better way to phrase this would have been to ask "which fragments run without generating an error".

    PS: The above is not meant to criticize, but to help Lokesh and other question authors think about possible ambiguity when submitting future QotD's.

    i TOTALLY AGREE WITH YOUR POINT HERE.

  • September 25, 2012 at 8:32 am

    #1541904

    Good question...

  • September 25, 2012 at 8:32 am

    #1541905

    Good question.

    Nice blg entry too, apart from "BACKUP/BACKUP" instead of "BACKUP/RESTORE".

    Tom

  • September 25, 2012 at 9:38 am

    #1541955

    DugyC (9/25/2012)

    Gaarrr!!! :angry:

    Even though I knew the answer was "Success, Fail, Success" for some dumb @ss reason I clicked the inversion and selected "Fail, Success, Fail" aaaaargh!!

    :w00t:

    I also have had bouts of dyslexia, especially before the first coffee cup. 😀

  • September 25, 2012 at 9:50 am

    #1541964

    Loved the question! :w00t:

    Best regards,

    Andre Guerreiro Neto

    Database Analyst
    http://www.softplan.com.br
    MCITPx1/MCTSx2/MCSE/MCSA

  • September 25, 2012 at 11:28 am

    #1541999

    A really nice question. Thanks, Lokesh!

  • September 25, 2012 at 12:25 pm

    #1542034

    Great question. Didn't know some DDL could/couldn't be used within a transaction. Good to learn something new. Thank you, Lokesh.

    "El" Jerry.

    "A watt of Ottawa" - Gerardo Galvan

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

  • September 25, 2012 at 11:33 pm

    #1542207

    L' Eomot Inversé (9/25/2012)

    Good question.

    Nice blg entry too, apart from "BACKUP/BACKUP" instead of "BACKUP/RESTORE".

    Thanks Tom!

    I have updated the blog now 🙂

    ~ Lokesh Vij

    Guidelines for quicker answers on T-SQL question[/url]
    Guidelines for answers on Performance questions

    Link to my Blog Post --> www.SQLPathy.com[/url]

    Follow me @Twitter

  • September 26, 2012 at 9:46 am

    #1542507

    L' Eomot Inversé (9/25/2012)

    Good question.

    Nice blg entry too, apart from "BACKUP/BACKUP" instead of "BACKUP/RESTORE".

    +1

    I have you followed but for whatever reason didn't get an email about the new post. For anyone who missed the link earlier it's here[/url].

    Kenneth FisherI was once offered a wizards hat but it got in the way of my dunce cap.--------------------------------------------------------------------------------For better, quicker answers on T-SQL questions, click on the following... http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]For better answers on performance questions, click on the following... http://www.sqlservercentral.com/articles/SQLServerCentral/66909/[/url]Link to my Blog Post --> www.SQLStudies.com[/url]

  • September 27, 2012 at 3:03 am

    #1542762

    I also mused over the interpretation of 'success' before choosing my answer, and selected the wrong interpretation (I thought 'success' meant successfully rolling back.)

    However I also got it wrong on another point so no harm done :o)

    -------------------------------Oh no!

  • October 3, 2012 at 4:47 pm

    #1545268

    Nice question

    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

Viewing 12 posts - 16 through 26 (of 26 total)

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