Viewing 15 posts - 46 through 60 (of 163 total)
g.maxfield (8/7/2015)
Sorry but I think the question was misleading/unclear. All were valid Object Reference Format of object names.
I don't agree with you. The examples you provided are valid, but...
August 7, 2015 at 3:27 am
For me the first insert worked, and the second failed with a constraint error. However my indexes were not disabled.
So I choose the most matching answer, but that was incorrect....
June 10, 2015 at 12:56 am
BWFC (5/26/2015)
Did I miss something when I only selected one answer and got it wrong because two were required?
Yes, the second part of the correct answer. 😀
May 26, 2015 at 1:42 am
Good question. Learned something here.
Expected the UNKNOWN to result in a constraint violation.
May 1, 2015 at 5:26 am
I am using both SSDT and SSMS. I am doing database maintenance and development.
Since a few years I started to use the Data Dude components for all our projects. In...
March 27, 2015 at 5:00 am
Stewart "Arturius" Campbell (3/26/2015)
If there is a Syntax error in the script to create a job, the job will not be created.
Correct, so in that case you can't run the...
March 26, 2015 at 5:44 am
I have to agree with the others: this is a badly worded QOTD and it has an incorrect answer too.
The answer should be yes.
Please correct the answer and give everyone...
March 26, 2015 at 4:11 am
Jeff Moden (2/6/2015)
February 6, 2015 at 8:47 am
I choose GROUPING, and still think it is the correct answer.
As others already said COUNT only doesn't ignore NULLs when used with the *. But * is not a...
January 7, 2015 at 9:01 am
0 points out of 2. Will try to select an incorrect answer tomorrow to see if I get a point. 😛
October 16, 2014 at 2:41 am
Agree with the others that "none of the above" the correct answer is.
In fact the correct answer should have been "none of the above and below", since there was...
October 15, 2014 at 7:53 am
TomThomson (10/7/2014)
marsigme (10/7/2014)
To add archival compression, use ALTER TABLE (Transact-SQL) or ALTER INDEX (Transact-SQL) with the REBUILD...
October 7, 2014 at 8:16 am
Carlo Romagnano (9/23/2014)
Triggers on tables execute only if at least ONE row is affected. So, explanation is wrong.
Hi Carlo,
you are wrong in your assumption. And I guess the idea behind...
September 23, 2014 at 2:32 am
Not a fan of synonyms. They should only be used when you have a real need, and I don't know what that would be.
"Simplify object names" is according to me...
September 11, 2014 at 2:17 am
Selected, as the most of us, the wrong correct answer.
Guess Steve was anticipating already the more complex MERGE question using a <target_table> option... 😀
September 9, 2014 at 2:46 am
Viewing 15 posts - 46 through 60 (of 163 total)