Viewing 15 posts - 451 through 465 (of 583 total)
codebyo (11/9/2011)
It made my brain hurt for a second.
I've got 3/4 options right.
I only missed one which should have been basic knowledge to me:
"The amount of space...
November 9, 2011 at 6:09 am
Koen Verbeeck (11/2/2011)
Nice question. It was tempting to select FOR, AFTER, INSTEAD OF :-D.
Right there with you. Then I realized the third member (with AFTER and INSTEAD OF) of the...
November 2, 2011 at 6:26 am
Not only was the question a good one, but the explanation was clear and well presented. Plus, the question didn't use a lot of unnecessary code to make the point....
November 1, 2011 at 5:40 am
Ernie Schlangen (10/31/2011)
October 31, 2011 at 7:29 am
Hugo Kornelis (10/31/2011)
Thomas Abraham (10/31/2011)
October 31, 2011 at 6:04 am
As I write, the answers are running 52% correct. Kind of makes me wonder why 48% can't use Google. I had to, as I must have killed off those brain...
October 31, 2011 at 5:36 am
Not the first time using SSMS help has steered me in the wrong direction. I'm learning.
Thanks for the question.
October 28, 2011 at 5:35 am
L' Eomot Inversé (10/27/2011)
... because I think it's far more common for a past participle in English to imply completed action than commencement of action ...
I couldn't have said it...
October 27, 2011 at 8:30 am
tommyh (10/27/2011)
October 27, 2011 at 6:27 am
I stopped processing when I saw that #3 was clearly incorrect, leaving the other 3 true by elimination and the specification of three correct answers. In a hurry this morning...
October 26, 2011 at 5:51 am
codebyo (10/25/2011)
Almost got it wrong because I couldn't see the error in query #7 (there were 5 values being passed to 4 columns).
#7 fails because personname is declared NOT NULL...
October 25, 2011 at 5:57 am
Excellent! Thanks for the question. And thanks to others for the discussion of TOP 100 percent. I didn't realize the optimizer would throw that out. Of course, I've never used...
October 21, 2011 at 5:36 am
mohammed moinudheen (10/20/2011)
vk-kirov (10/19/2011)
Resource Governor Concepts
October 20, 2011 at 5:42 am
Kwex (10/19/2011)
Thanks guys!Due to the length of time that had gone by when I submitted the question, I almost forgot the answer 🙂
Kwex.
Same thing happened to me yesterday....
October 19, 2011 at 5:52 am
Thanks to OP for the question. And also to the others for their interesting comments. That's why I hang around the QotD so much - I tend to learn the...
October 18, 2011 at 5:51 am
Viewing 15 posts - 451 through 465 (of 583 total)