Viewing 15 posts - 4,441 through 4,455 (of 7,483 total)
Hugo Kornelis (5/29/2012)
Tom
May 29, 2012 at 10:23 am
Good question.
But my brain is not working right today. I thought to myself "can I execute a package if SSIS service isn't running? Yes, of course I can" and...
Tom
May 29, 2012 at 9:59 am
RBarryYoung (5/26/2012)
Heh, try searching SQL_MODULES for '%cursor%open%while%fetch%close%deallocate%', Tom. Those suckers have cursors in them!
Well, it's possible that that could occur within a string literal (or split across several string...
Tom
May 27, 2012 at 4:50 am
RBarryYoung (5/24/2012)
GilaMonster (5/23/2012)
dwain.c (5/22/2012)
Stefan Krzywicki (5/22/2012)
Lynn Pettis (5/22/2012)
If people would just format their code they could figure out some of their own problems. Geez.
Many should format it all at...
Tom
May 25, 2012 at 12:15 pm
lbrigham (5/24/2012)
Tom
May 25, 2012 at 12:01 pm
DugyC (5/24/2012)
Basic computer science question, nice and easy, thanks.Can't believe almost a third got it wrong!
Bak to skool! 😛
"computer science" question? Since when was T-SQL operator precedence part of...
Tom
May 24, 2012 at 5:48 am
Toreador (5/24/2012)
I can't believe that 21% have currently got it completely wrong, thinking that OR has precedence over AND! Hopefully they're just all misunderstanding what 'precedence' means 😉
It seems more...
Tom
May 24, 2012 at 5:28 am
roger.plowman (5/23/2012)
L' Eomot Inversé (5/23/2012)
roger.plowman (5/23/2012)
Having the default setting to OFF basically break transactions and is a *bug* in SQL Server.Explicit transactions should be exactly that, explicit.
That's the whole...
Tom
May 23, 2012 at 5:00 pm
roger.plowman (5/23/2012)
Having the default setting to OFF basically break transactions and is a *bug* in SQL Server.Explicit transactions should be exactly that, explicit.
That's the whole point of course: they...
Tom
May 23, 2012 at 10:20 am
michael vessey (5/23/2012)
The person who wrote the original code or the tester that allowed it to make it into production?
ahem.... the tester didn't put the defect there (the...
Tom
May 23, 2012 at 10:07 am
Lynn Pettis (5/23/2012)
Elliott Whitlow (5/23/2012)
Oliiii (5/23/2012)
Tom
May 23, 2012 at 10:03 am
Good question.
Unfortunately the explanation is all about implicit transactions, while the question is about an explicit transaction. So the explanation is not exactly helpful!
Tom
May 23, 2012 at 3:49 am
Gianluca Sartori (5/22/2012)
L' Eomot Inversé (5/22/2012)
Gianluca Sartori (5/22/2012)
Tom
May 22, 2012 at 4:44 pm
Viewing 15 posts - 4,441 through 4,455 (of 7,483 total)