April 5, 2016 at 8:13 pm
Comments posted to this topic are about the item Temporary Table Limitations
April 6, 2016 at 12:07 am
This was removed by the editor as SPAM
April 6, 2016 at 1:27 am
Good question!
I revised some features of temp tables.
April 6, 2016 at 2:31 am
GAH! I hate double negatives.
April 6, 2016 at 2:40 am
I agree with the comment about double negatives - it makes this question harder than it should be.
April 6, 2016 at 3:32 am
I don't disagree with the comment about the double negatives.
April 6, 2016 at 4:03 am
i feel double negatives are confusing.
April 6, 2016 at 4:18 am
According to this article a temporary table can be partitioned:
http://jasonbrimhall.info/2014/05/23/can-you-partition-a-temporary-table/.
So "Temporary tables cannot be partitioned" is not a limitation.
April 6, 2016 at 4:40 am
Double negatives seem the way to go for this question, however I do think some people use them to confuse the reader.
April 6, 2016 at 5:19 am
pmadhavapeddi22 (4/6/2016)
i feel double negatives are confusing.
I don't not fail to disagree that your statement is wrong
April 6, 2016 at 5:32 am
Nice question, even with the double negatives, triple negative comments, etc. It tripped me up, but who among us doesn't have to deal with double negatives (and worse) at work. It was still a good question.
April 6, 2016 at 5:57 am
I have not tried it out. However,
http://jasonbrimhall.info/2014/05/23/can-you-partition-a-temporary-table/
...states that partitioning is possible!?
April 6, 2016 at 6:46 am
morlindk (4/6/2016)
I have not tried it out. However,http://jasonbrimhall.info/2014/05/23/can-you-partition-a-temporary-table/
...states that partitioning is possible!?
Hence the answer.
April 6, 2016 at 7:12 am
Interesting question. But two of the "restrictions" are not restrictions and only one non-restriction is asked for. 😉
It was however easy to see which of them was the one that was wanted, just by looking at the wording - it was the only one not expressed as a negative; all the commenters complaining about "double negative" should have noticed that the one answer said "must have a different name than" (:sick: what a barbarous Americanism :laugh:)instead of "cannot have the same name as", avoiding the double negative, so was clearly the odd one out - ie the required answer.
Incidentally, only 37% of those who were marked wrong so far got it wrong by picking the wrong answer that was actually one of the two right answers. So half the answers to date had chosen neither of the actually right answers.
Of course the question says "which of these are" not "which of these is" so it's asking for more than one option to be selected; but it returns "wrong" when one right single selection is chosen and "righ" when the other right single selection is chosen.
Tom
April 6, 2016 at 7:19 am
Boooo, temp tables can be partitioned.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 15 posts - 1 through 15 (of 31 total)
You must be logged in to reply to this topic. Login to reply