Transaction Trio

Question

Transaction Trio

Viewing 13 posts - 16 through 27 (of 27 total)

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

Thomas Abraham SSChampion Points: 10761 More actions · Answer 1

Thanks for the Monday question. I was happy to begin the week with a question that didn't start with "When can normalising ...". 🙂

As for "Jeff.MSSqlSage", well, then let's see some more questions.

[font="Verdana"]Please don't go. The drones need you. They look up to you.[/font]
Connect to me on LinkedIn

Jeff.MSSqlSage Say Hey Kid Points: 709 More actions · Answer 2

Thomas Abraham (8/26/2013)
Thanks for the Monday question. I was happy to begin the week with a question that didn't start with "When can normalising ...". 🙂
As for "Jeff.MSSqlSage", well, then let's see some more questions.

When can normalising not be considered normalising, but still be normalising ?

Thomas Abraham SSChampion Points: 10761 More actions · Answer 3

Jeff.MSSqlSage (8/26/2013)
Thomas Abraham (8/26/2013)
Thanks for the Monday question. I was happy to begin the week with a question that didn't start with "When can normalising ...". 🙂
As for "Jeff.MSSqlSage", well, then let's see some more questions.
When can normalising not be considered normalising, but still be normalising ?

If one of the answers contains "L' Eomot Inversé", I'll pick that one. 😉

[font="Verdana"]Please don't go. The drones need you. They look up to you.[/font]
Connect to me on LinkedIn

TomThomson SSC Guru Points: 104773 More actions · Answer 4

Thomas Abraham (8/26/2013)
Jeff.MSSqlSage (8/26/2013)
Thomas Abraham (8/26/2013)
Thanks for the Monday question. I was happy to begin the week with a question that didn't start with "When can normalising ...". 🙂
As for "Jeff.MSSqlSage", well, then let's see some more questions.
When can normalising not be considered normalising, but still be normalising ?
If one of the answers contains "L' Eomot Inversé", I'll pick that one. 😉

Then I could catch you out easily, by changing my handle. :hehe:

Tom

PHYData DBA SSCertifiable Points: 7541 More actions · Answer 5

Nice easy Monday question. Why I have yet to convert code to use table variables.

Ken SSCoach Points: 17191 More actions · Answer 6

Thankfully I don't use enough table variables to have ever run into this scenario. Good information to know. Thanks for the question!

PHYData DBA SSCertifiable Points: 7541 More actions · Answer 7

L' Eomot Inversé (8/26/2013)
Good question, and really terrific reference. That page should debunk many widely believed myths and isn't propagating any, which is quite unusual for a page that talks about the differences between temp tables and table variables.

+1

mickyT SSChampion Points: 10360 More actions · Answer 8

mickyT

SSChampion

Points: 10360

August 26, 2013 at 1:36 pm

#1644956

Nice question thanks

sqlnaive SSCoach Points: 17437 More actions · Answer 9

sqlnaive

SSCoach

Points: 17437

September 2, 2013 at 1:24 am

#1646678

Really terrific question. Thumbs up. 🙂

udayroy15 Ten Centuries Points: 1076 More actions · Answer 10

Table variable will not affected by ROLLBACK cmd...........

Dscheypie SSCommitted Points: 1545 More actions · Answer 11

Good question, and even better reference. Thanx!

________________________________________________________
If you set out to do something, something else must be done first.

jfgoude SSCrazy Points: 2586 More actions · Answer 12

2 easy points.

guessed well as I know why, but you should definitively never award two points or more when it's so easy to copy / paste question in SSMS

Paul_Wheeler SSC Journeyman Points: 76 More actions · Answer 13

Great to learn new things! Wish I'd had this question a few years ago... might have made logging those failed transactions easier!