Viewing 15 posts - 121 through 135 (of 233 total)
Well, the traceflag doesn't control anything except parallelism of DBCC:
Disables parallel checking of objects by...
November 24, 2017 at 1:44 am
Nice one. I got it wrong, simply because I figured adding two dates just doesn't make any sense, and so the result should be the strings concatenated.
October 5, 2017 at 1:05 am
Bzzzt!
September 29, 2017 at 12:04 am
One trillion integers won't fit in an INT column so a...
September 26, 2017 at 8:01 am
September 26, 2017 at 7:50 am
Interesting. However, the question doesn't actually say if those are one trillion different integers, or if there are repetitions. If there are one trillion different values, I doubt there will...
September 26, 2017 at 12:32 am
These questions certainly require a fair bit of mind reading to get "correct". But remembering the debacle from the previous installment and the following discussion, CEILING will accomplish what Steve...
August 22, 2017 at 1:15 am
Doh! I missed the "Distributed" part of the heading. There's nothing in the docs about regular replay that says anything about versions for replay targets.
August 17, 2017 at 4:48 am
Have to agree with the above. I have to admit I didn't really understand what Steve was trying to achieve, but I still got points because that was the only...
July 31, 2017 at 2:17 am
Just pitching in for #4 to get a point.
May 23, 2017 at 2:01 pm
Nice try...
Quite interestingly, not even the link to the supporting MSDN article is correct.
February 8, 2017 at 3:16 am
Russell Shilling (1/10/2017)
The
isnull(left(@b,3),'I ô Char') as ba
will also return the string. The left function of @b-2...
January 10, 2017 at 11:34 pm
Thank you very much, Uwe!
That was a very enlightening question and explanation. Definitely something to add to the tool belt for those pesky edge cases.
January 5, 2017 at 3:47 am
DOH! It was INvalid! Time for coffee...
November 2, 2016 at 12:36 am
Viewing 15 posts - 121 through 135 (of 233 total)