Viewing 15 posts - 151 through 165 (of 178 total)
I think this is the first question I instantly knew the answer to, as pointed out I guess Steve prepared us for this one.
Need to get my eyes tested though,...
January 20, 2011 at 2:00 am
Took a while over this as was debating with myself wether "user defined" pools, which are also available with Resource Governor, counted as "Guest" pools. In the end I decided...
January 14, 2011 at 3:25 am
Good question. In all my google'ing I couldn't get a definite answer, and still couldn't even in the linked article associated with the answer.
Ended up applying commonsense, and 50/50 with...
January 12, 2011 at 3:24 am
God damn it!! I would have got this one right had I read the MSDN linked page properly, it was my reference from google.
I assumed VARCHAR & NVARCHAR would be...
January 11, 2011 at 2:18 am
Good question, but another lost point for me 🙁
Didn't read the question properly and misunderstood the "INSERTED table" reference. Once I understood that, the answer was easy to find. Bummer.
Question...
January 10, 2011 at 3:10 am
Great question, learnt something new.
After reading the editorial and browsing Kimberly Tripps blog, I found it amusing that the google search first item was... Kimberly Tripps blog... coincidence? 😉 ...somehow...
January 7, 2011 at 2:24 am
Hardy21 (11/23/2010)
Try
INSERT INTO #
SELECT 'ASDF'
GO 0
GO <ZERO> --- SQL doesn't throw any complilation error but when you execute the code, status bar should display: "Query completed with errors".
Nope, doesn't...
November 23, 2010 at 3:51 am
da-zero (11/23/2010)
November 23, 2010 at 3:18 am
Richard Warr (11/16/2010)
November 16, 2010 at 4:45 am
Mighty (11/11/2010)
Looking at the percentage of incorrect results, and the percentages per answer, I wonder if people missed the "in" in "incorrect" in the question.
Yep, that's what happened to me!...
November 11, 2010 at 2:30 am
I'm absolutely gob smacked somebody answered 29Apr, or even worse 31Mar. :ermm:
I'll give them the benefit of the doubt though and presume they suspected a trick question. 😀
Agree with the...
October 27, 2010 at 3:08 am
Good question but, regardless of whether it was a "deception" or to "throw people off the scent", the lesson was lost in the absence of the fourth option for "1...
September 29, 2010 at 2:23 am
Just adding another voice to the "I selected the correct answer yet was still marked wrong".
I'm sorry but, as pointed out above, the Resource database can be moved in SQL2005......
September 9, 2010 at 2:31 am
Viewing 15 posts - 151 through 165 (of 178 total)