Transactions

Question

Post reply

Transactions

Lokesh Vij

SSChampion

Points: 10836
More actions
September 24, 2012 at 9:01 pm

#264705

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
September 25, 2012 at 5:55 am

This was removed by the editor as SPAM

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

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

Ron McCullough SSC Guru Points: 63877 More actions · Answer 1

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 SSCoach Points: 17191 More actions · Answer 2

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

Lokesh Vij SSChampion Points: 10836 More actions · Answer 3

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: 259105 More actions · Answer 4

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: 6099 More actions · Answer 5

Really very good information. Keep it up !

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

Hugo Kornelis SSC Guru Points: 64790 More actions · Answer 6

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 More actions · Answer 7

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 More actions · Answer 8

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 More actions · Answer 9

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: 438 More actions · Answer 10

Jinxseee

SSC-Addicted

Points: 438

September 25, 2012 at 3:19 am

#1541717

Thanks! Learned something.

DugyC Hall of Fame Points: 3804 More actions · Answer 11

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: 15943 More actions · Answer 12

Divine Flame

SSCoach

Points: 15943

September 25, 2012 at 4:44 am

#1541770

Good one. 😎

Sujeet Singh

Dana Medley SSCertifiable Points: 6764 More actions · Answer 13

Thank you for the great question.

Everything is awesome!