Viewing 15 posts - 151 through 165 (of 179 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,...
_____________________________________________________________________
[font="Comic Sans MS"]"The difficult tasks we do immediately, the impossible takes a little longer"[/font]
January 20, 2011 at 2:00 am
Easy money, cheers!
_____________________________________________________________________
[font="Comic Sans MS"]"The difficult tasks we do immediately, the impossible takes a little longer"[/font]
January 19, 2011 at 1:56 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...
_____________________________________________________________________
[font="Comic Sans MS"]"The difficult tasks we do immediately, the impossible takes a little longer"[/font]
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...
_____________________________________________________________________
[font="Comic Sans MS"]"The difficult tasks we do immediately, the impossible takes a little longer"[/font]
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...
_____________________________________________________________________
[font="Comic Sans MS"]"The difficult tasks we do immediately, the impossible takes a little longer"[/font]
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...
_____________________________________________________________________
[font="Comic Sans MS"]"The difficult tasks we do immediately, the impossible takes a little longer"[/font]
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...
_____________________________________________________________________
[font="Comic Sans MS"]"The difficult tasks we do immediately, the impossible takes a little longer"[/font]
January 7, 2011 at 2:24 am
Toreador (12/17/2010)
How many times do we have to have questions about the default precision of strings before everyone gets them right?!
Never, there will always be somebody new.
Good simple question, perfect...
_____________________________________________________________________
[font="Comic Sans MS"]"The difficult tasks we do immediately, the impossible takes a little longer"[/font]
December 17, 2010 at 2:54 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...
_____________________________________________________________________
[font="Comic Sans MS"]"The difficult tasks we do immediately, the impossible takes a little longer"[/font]
November 23, 2010 at 3:51 am
da-zero (11/23/2010)
_____________________________________________________________________
[font="Comic Sans MS"]"The difficult tasks we do immediately, the impossible takes a little longer"[/font]
November 23, 2010 at 3:18 am
Richard Warr (11/16/2010)
_____________________________________________________________________
[font="Comic Sans MS"]"The difficult tasks we do immediately, the impossible takes a little longer"[/font]
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!...
_____________________________________________________________________
[font="Comic Sans MS"]"The difficult tasks we do immediately, the impossible takes a little longer"[/font]
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...
_____________________________________________________________________
[font="Comic Sans MS"]"The difficult tasks we do immediately, the impossible takes a little longer"[/font]
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...
_____________________________________________________________________
[font="Comic Sans MS"]"The difficult tasks we do immediately, the impossible takes a little longer"[/font]
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......
_____________________________________________________________________
[font="Comic Sans MS"]"The difficult tasks we do immediately, the impossible takes a little longer"[/font]
September 9, 2010 at 2:31 am
Viewing 15 posts - 151 through 165 (of 179 total)