Viewing 15 posts - 106 through 120 (of 230 total)
ildjarn.is.dead - Thursday, January 18, 2018 2:10 AMSQL 2015?
It's a special release only Steve has😛
January 18, 2018 at 2:13 am
I got it right. Collations are tricky business. I think this is one case where people from countries that don't use English as their primary language have an edge.
January 18, 2018 at 2:06 am
Interesting. If you look in the linked documentation, you're led to believe that the ... FILE = NUL syntax (without the single quotes) is the correct one, but clearly that...
January 12, 2018 at 12:32 am
One has to admire Steve's tenacity at getting questions slightly bent.:hehe:
December 29, 2017 at 12:35 am
Very hard to know if 'Adult' refers to the Age or Genre for the movie "'s a wonderful life"...
December 28, 2017 at 12:30 am
Interesting question, but I would argue that R isn't "smart enough to know that the last parameter, unnamed, is second", but rather that R is "stupid enough to not complain...
December 20, 2017 at 1:07 am
December 15, 2017 at 12:44 am
Not sure I follow the reasoning behind the correct answers. WITH CUBE returns more rows, but not WITH ROLLUP. And yet they return the same number of rows? How is...
December 14, 2017 at 1:17 am
If you look anywhere outside of the database world, I'm pretty sure you'd get a pretty unequivocal answer: You have, for example, a number of objects/structures/tuples/rows that are manifestations of...
December 8, 2017 at 1:40 am
RoNoS - Wednesday, December 6, 2017 12:39 AMIsn't that giving a syntax error about a missing bracket?
That would be my guess as...
December 6, 2017 at 1:33 am
December 5, 2017 at 1:26 am
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
Viewing 15 posts - 106 through 120 (of 230 total)