Transactions

  • Lokesh Vij

    SSChampion

    Points: 10836

    Comments posted to this topic are about the item Transactions

    ~ 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

  • Ron McCullough

    SSC Guru

    Points: 63877

    Nice easy question - thanks

    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]

  • Ken Wymore

    SSCoach

    Points: 16611

    I shouldn't try to answer the QOTD when I have been working for 15 hours. Nice question Lokesh!

  • Lokesh Vij

    SSChampion

    Points: 10836

    A little attempt from me to make "DDL inside transactions" more informative. Hope you all like it 🙂

    http://sqlpathy.wordpress.com/2012/09/25/myth-truncate-cannot-rollback/

    ~ 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

  • Koen Verbeeck

    SSC Guru

    Points: 258965

    Nice question, thanks.

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

  • Vinay Kumar

    SSCertifiable

    Points: 6098

    Really very good information. Keep it up !

    Thanks
    Vinay Kumar
    -----------------------------------------------------------------
    Keep Learning - Keep Growing !!!

  • Hugo Kornelis

    SSC Guru

    Points: 64685

    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.


    Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
    Visit my SQL Server blog: https://sqlserverfast.com/blog/
    SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/

  • Raghavendra Mudugal

    SSChampion

    Points: 10658

    Interesting one.:-) thank you Lokesh-ji

    ww; Raghu
    --
    The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.

  • Lokesh Vij

    SSChampion

    Points: 10836

    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.

    Thanks Hugo. Much appreciated 🙂

    ~ 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

  • demonfox

    SSCertifiable

    Points: 6289

    nice and easy ...

    I must say i like the permutation ..I had to search the answer within multiple options ..

    Thanks for the question !!

    ~ demonfox
    ___________________________________________________________________
    Wondering what I would do next , when I am done with this one :ermm:

  • Jinxseee

    SSC-Addicted

    Points: 408

    Thanks! Learned something.

  • DugyC

    Hall of Fame

    Points: 3804

    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:

    _____________________________________________________________________
    [font="Comic Sans MS"]"The difficult tasks we do immediately, the impossible takes a little longer"[/font]

  • Divine Flame

    SSCoach

    Points: 15941

    Good one. 😎


    Sujeet Singh

  • This was removed by the editor as SPAM

  • Dana Medley

    SSCertifiable

    Points: 6764

    Thank you for the great question.



    Everything is awesome!

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

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