Viewing 15 posts - 4,441 through 4,455 (of 7,484 total)
Jeff Moden (5/29/2012)
Grant Fritchey (5/29/2012)
May 29, 2012 at 11:21 am
Hugo Kornelis (5/29/2012)
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...
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...
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...
May 25, 2012 at 12:15 pm
lbrigham (5/24/2012)
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...
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...
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...
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...
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...
May 23, 2012 at 10:07 am
Lynn Pettis (5/23/2012)
Elliott Whitlow (5/23/2012)
Oliiii (5/23/2012)
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!
May 23, 2012 at 3:49 am
Viewing 15 posts - 4,441 through 4,455 (of 7,484 total)