Forum Replies Created

Viewing 15 posts - 16 through 30 (of 92 total)

  • RE: Fun with OVER

    Louis Hillebrand (6/26/2014)


    Interesting, but when I change the order of the rows in the insert (Mary before Anita) the order of the rows in query C changes.

    The result of Query...

  • RE: Alas Poor Snapshot, I Knew Him Well

    arthurolcot (3/20/2014)


    Great quality question.. Content (and humour!) aside, the question itself actually made you think and apply logic to come up with the most likely correct answer (which we all...

  • RE: EXCEPT 2

    Raghavendra Mudugal (3/3/2014)


    KWymore (3/2/2014)


    Carlo Romagnano (3/2/2014)


    Igor Micev (3/2/2014)


    Question is identical with that of 2014/02/26.

    The answer is also identical.

    Am I missing something?

    +1

    But where is EXCEPT-1?

    Why, if the qotd is identical to...

  • RE: SQL Server Health and History Tool

    Nice question to introduce a handy tool. Thanks... Agree that "Select All the Apply" with a radio button doesn't exactly give you much choice.

  • RE: DBCC CHECKIDENT

    This looks very similar to the question about a week ago... So a nice easy way to end a friday. 🙂

  • RE: Thanksgiving 2013

    Happy Thanksgiving!

  • RE: Minimum Number of VLFs

    Great question thanks - had to research this one to make sure, which is always useful.

  • RE: Sequence

    Nice easy question. Thanks.:-)

  • RE: SSIS

    Although easy if you know it and logical if you don't (since the other three aren't actually database tasks).

    I don't think the documentation is very clear in highlighting the limitation,...

  • RE: wildcards

    Given the title of the question, I guessed that the 11 character value to be inserted was an oversight! Otherwise great question and nice to learn something new.

  • RE: CASE vagaries

    Very strange question indeed - given that you can only end up with either of two answers, and then the fact that it caters for NULL, you can eliminate that...

  • RE: Expressions

    Definitely learnt something new today! Was very confused at first but a great explanation too - makes it simple. - Thanks.

  • RE: Isolation levels

    Was looking for the trick in the question - great back to basics. Thanks.

  • RE: SSIS 2012 -Template

    L' Eomot Inversé (8/4/2013)


    Nice question.

    The answer seemed a bit obvious though - the phrase " Import Project Wizard" suggested that importing an SSIS project would be what was...

  • RE: DBCC CHECKDB

    Great reminder question - thanks Steve.

Viewing 15 posts - 16 through 30 (of 92 total)