Viewing 15 posts - 6,931 through 6,945 (of 7,484 total)
Well, I ticked the least wrong answer and got a point.
Archiving to a separate system may well be overkill, and may damage the performance quite seriously when those rare queries...
April 27, 2010 at 1:46 am
Adam Machanic (4/26/2010)
Tom.Thomson (4/26/2010)
April 26, 2010 at 9:24 pm
Well, it was pretty obvious what the author thought was the first rule, so I got my point. But I believe the right answer isn't actually in the list...
April 26, 2010 at 8:31 pm
I think the suggested answer is the wrong way to do it. The sensible thing to do is either use a thread and communicate by messaging (have that thread...
April 26, 2010 at 8:20 pm
Paul White NZ (4/26/2010)
+1. I didn't even bother to Google - I waited for the correct answer to be mailed to me today 😉
I was surprised by the number...
April 26, 2010 at 7:33 pm
A brilliant article. Keep it up!
April 26, 2010 at 7:08 pm
Jeff Moden (4/24/2010)
April 26, 2010 at 6:49 pm
Adam Machanic (4/26/2010)
April 26, 2010 at 5:18 pm
Amit-695544 (4/4/2008)
hi friends !!I am sorry but is this a bug, MS's overesmartness of type conversion or somthing logical thing. :w00t:
Please be clear.
Thanks .
My take is that MS decided to...
April 25, 2010 at 2:25 pm
Adam Machanic (2/4/2005)
April 25, 2010 at 2:02 pm
Matt Marston (2/4/2005)
<FONT color=#111111>Wouldn't the correct answer be </FONT><FONT color=#00008b>'This is an interesting table ' </FONT><FONT color=#111111>(with an extra space on the end)? </FONT>
Yes.
April 25, 2010 at 2:00 pm
Adam Machanic (12/17/2004)
print convert(varchar(3), 0x697320) +
convert(varchar(5), 0x747279696E) +
convert(varchar(1), 0x67) +
convert(varchar(7), 0x20746F206D616B) +
convert(varchar(4), 0x65206869) +
convert(varchar(3), 0x6D7365) +
convert(varchar(8), 0x6C66207365656D20) +
convert(varchar(1),...
April 25, 2010 at 11:28 am
CirquedeSQLeil (12/13/2009)
Doh - version based question where the results change.SSMS 2005 and 2008 both gave me 3.4
Perhaps at the date the question was set it was reasonable to assume sql...
April 25, 2010 at 11:16 am
Steve Jones - Editor (11/18/2004)
April 25, 2010 at 10:34 am
Steve Jones - Editor (10/10/2009)
Comments posted to this topic are about the item <A HREF="/articles/books/67141/">SQL Server Stumpers, Vol.5</A>
Are vols 1 to 4 still around?
April 25, 2010 at 10:02 am
Viewing 15 posts - 6,931 through 6,945 (of 7,484 total)