Forum Replies Created

Viewing 15 posts - 61 through 75 (of 110 total)

  • RE: GO

    cfradenburg (6/7/2011)

    wware (6/7/2011)

    I fear this question got lost in the hubbub about the obvious mismatch of the question/answers. I would also appreciate some insight into this. Thanks.

    Funny how...

    June 7, 2011 at 7:45 am

    #1335014

  • RE: GO

    Iggy-SQL (6/7/2011)

    I got it right, but I just wonder, if GO is meant to take an optional [count], why does it has the red squiggly underline mark when writing it...

    June 7, 2011 at 7:25 am

    #1334995

  • RE: Heaps

    Tom.Thomson (5/6/2011)

    ...drank probably more than I should have when that tired, and started looking at SQLSC...

    So, are you guilty of PUI (Posting Under the Influence)? ...

    May 6, 2011 at 10:25 am

    #1321150

  • RE: Running as SysAdmin

    True story: Blank SA password, long-time developer knows this, long-time developer laid off, delay in revoking long-time developer's Remote Desktop privileges and network login.

    No, nothing happened. Long-time...

    May 4, 2011 at 1:37 pm

    #1320064

  • RE: Heaps

    Steve Jones - SSC Editor (5/4/2011)

    Chris Houghton (5/4/2011)

    Nice technical question Steve. Are some of these recent questions resulting from you studying for the MCM Certification?

    They are. I'm trying to...

    May 4, 2011 at 1:11 pm

    #1320054

  • RE: OUTPUT & NEWID()

    Interesting question. I had no problem with the semantics of the question or answer.

    Wondering if anyone can think of a real world example where one might want...

    April 25, 2011 at 7:29 am

    #1315418

  • RE: Money and Decimal Datatypes

    Thanks for the question! We should make a rule that all Monday QOTD have to be "back to basics" type of questions, mirroring the The New York Times crossword...

    April 18, 2011 at 11:44 am

    #1312989

  • RE: Length

    ambigla (4/7/2011)

    Today I thought "Finally! An easy one!!" and specified 4 only to find out the question wasn't checked properly and I ended up getting it wrong anyway :crazy: It's...

    April 8, 2011 at 11:46 am

    #1309323

  • RE: Dating for DBAs

    shivani_aggarwal09 (4/8/2011)

    all the formts are correct their is no error. firstly among the 4 we can not seclect any 2 bcoz of the all 4 are right. i was schoked...

    April 8, 2011 at 5:40 am

    #1309058

  • RE: Dating for DBAs

    Duncan Pryde (4/6/2011)

    I'm glad people are liking the question - thanks for the positive comments everyone.

    I was motivated to come up with the question after following a discussion relating to...

    April 6, 2011 at 12:19 pm

    #1308193

  • RE: Creating an Indexed View

    Patrick2525 (3/30/2011)

    I think now I know why the cert exams don't let you know which questions you missed - imagine the backlash! 😀

    Ha! So true!

    March 30, 2011 at 1:01 pm

    #1305635

  • RE: Creating an Indexed View

    Patrick2525 (3/30/2011)

    Actually, I've been doing a lot of the MCTS Self-study guides and exams from various vendors the past few months to prepare for the exams (passed 2 recently). This...

    March 30, 2011 at 12:13 pm

    #1305607

  • RE: T-SQL

    Gopi>>The important thing that i want to bring out is the datatype of the final result set is based on the first statement in the insert list.

    The examples in your...

    March 22, 2011 at 7:36 am

    #1301871

  • RE: Scaled-down SQL

    It's unanimous...great question, Duncan! Keep 'em coming.

    March 21, 2011 at 12:29 pm

    #1301482

  • RE: Data conversion

    Great question...a lot of points to ponder!

    I had no problem with the implicit conversions.

    I'm fascinated to learn you can use data types as column names.

    (This is good to know so...

    March 18, 2011 at 8:15 am

    #1300525

Viewing 15 posts - 61 through 75 (of 110 total)