Forum Replies Created

Viewing 15 posts - 3,031 through 3,045 (of 3,348 total)

  • RE: one character of data

    Tom Garth (6/13/2009)


    Never have I learned so much from a single dimwitted attempt at humor.

    Thanks, Tom.

    But boy, do I need to re-adjust my sarcasm detector. Man, you even used TWO...

  • RE: one character of data

    Tom Garth (6/12/2009)πŸ™‚Hugo - How do you store a NULL?πŸ™‚

    In the storage area of every row, one or more bytes are reserved for the so-called "null bitmap". If the table...

  • RE: one character of data

    This is one of the worst QotD's of this year. Not because of the question (which is fair [*]), but because of available answer options, the answer considered correct, and...

  • RE: Maximum instances supported by SQL Server 2008

    craigpessano (5/18/2009)


    I did a little more digging and found the following link that indicates 50 for Enterprise, and 16 for Standard and other editions.

    Good catch! (Goes for Noel too).

    I'll ping...

  • RE: Maximum instances supported by SQL Server 2008

    Lynn Pettis (5/17/2009)


    I have to agree, the wording of the question is questionable.

    Questionable? It's not questionable, it's plain wrong.:angry:

    Standard edition supports 50 instances. Workgroup edition is limited to 16.

    Standard !=...

  • RE: SELECT FUN

    saurabh.dwivedy (5/7/2009)


    I got it wrong because I thought TWO NULL Values are NOT supposed to be same(identical). So I chose the option with 3 rows. Quirk of SQLServer?

    No quirk. Expected...

  • RE: Weird datetime conversions

    Jan Van der Eecken (5/7/2009)


    Apart from the formatting issue, what does it really mean if one adds two dates together?

    Nothing. The explanation is in fact misleading, since that is not...

  • RE: Weird datetime conversions

    RBarryYoung (5/6/2009)


    I couldn't really read this question, It was all just IFCodes.

    The code was properly formatted in the daily mail, but not on the site. For those who have lost...

  • RE: SELECT FUN

    I know the test developer couldn't have made a mistake

    Hi Reginald,

    Do I sense some sarcasm there? πŸ˜‰

    Anyway, if you selected both #1 and #2, then you should have gotten the...

  • RE: Dynamic Query

    Atif Sheikh (5/4/2009)


    Very Tricky...

    The last query DO NOT Execute due to the the @query variable declared as varchar(20)

    if You declare the @query variable as varchar(25), it executes.

    Nice...

    It'll execute all...

  • RE: SELECT FUN

    Arsi Salo (4/24/2009)


    ... And now the original correct choice does not give point...:ermm:

    ... which is entirely correct, since the question has been changed to (emphasis mine):

    "What can be the output...

  • RE: T-SQL Operators

    sjimmo (4/23/2009)


    I should have read the responses before answering - I also must have missed that class, but when did MTX become part of T-SQL? Everyone who answered without the...

  • RE: TOP

    Rachel Byford (4/23/2009)


    This is a really informative thread (as was yesterday's).

    hakan.winther (4/23/2009)


    thank you for your time to share your knowledge about SQL Server internal processes.

    GSquared (4/23/2009)


    Good discussion.

    Thanks, all three of...

  • RE: TOP

    hakan.winther (4/23/2009)


    I agree that you cannot be 100% sure of what method will be chosen by the SQL optimizer, but in this case the index scan would be much more...

  • RE: TOP

    hakan.winther (4/23/2009)


    Carlo Romagnano (4/23/2009)


    I disagree! See the question of yesterday.

    I do not understand why you disagree? Do you want to be more specific?

    Hi HΓ₯kan,

    The QotD of yesterday sparked a...

Viewing 15 posts - 3,031 through 3,045 (of 3,348 total)