Forum Replies Created

Viewing 15 posts - 316 through 330 (of 673 total)

  • RE: STUFF Function

    Carlton Leach (5/18/2011)


    Another bug vote here, and another wrong answer for me.

    NULL is NULL...fullstop. You never know what NULL is so regardless if you insert, concatenate, stick it somewhere in...

  • RE: STUFF Function

    Koen Verbeeck (5/17/2011)


    Tom.Thomson (5/17/2011)


    I've submitted a connect item[/url] suggesting this behavious be changed.

    voted +1

    What would you recomend they change the behavior to?

    The function would still need to return at...

  • RE: STUFF Function

    Nice question. Easy answer for me, but I have used string functions a lot.

    I understand all the comments about a BUG, or BOL not getting it right. The...

  • RE: Page Compression

    Nice easy Monday question. 😎

  • RE: Know Your SQL Objects

    Tom.Thomson (5/13/2011)


    that Dutchmen (on at least one of them) think that English "may" always means "may or may not" and can't be used unless "may not" and "may" are both...

  • RE: Know Your SQL Objects

    Ninja's_RGR'us (5/13/2011)


    SanDroid (5/13/2011)


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


    Hugo Kornelis (5/13/2011)


    WHAAT???

    In the daily newsletter, the question specifies to "select 4". Which is what I did. And then I find that the...

  • RE: Know Your SQL Objects

    Paul Randal (5/13/2011)


    Steve - I got this wrong because your wording is broken. Extents can NOT be owned by multiple objects. When an extent is a mixed extent, it is...

  • RE: Know Your SQL Objects

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


    Hugo Kornelis (5/13/2011)


    WHAAT???

    In the daily newsletter, the question specifies to "select 4". Which is what I did. And then I find that the site thinks...

  • RE: Know Your SQL Objects

    Ninja's_RGR'us (5/13/2011)


    SanDroid (5/13/2011)


    Brandie Tarvin (5/13/2011)


    Um, no. Because it defeats the purpose of the QOTD. If everyone knew what the QOTD was going to be and all its potential answers BEFORE...

  • RE: Know Your SQL Objects

    Brandie Tarvin (5/13/2011)


    Um, no. Because it defeats the purpose of the QOTD. If everyone knew what the QOTD was going to be and all its potential answers BEFORE it became...

  • RE: Know Your SQL Objects

    Brandie Tarvin (5/13/2011)


    Don't believe me? Then I have an interesting exercise for you to try.....

    I like that suggestion Brandie.

    I would suggest submitting a question and then defending that...

  • RE: Know Your SQL Objects

    calvo (5/13/2011)


    John Mitchell-245523 (5/13/2011)


    ... But, as has been pointed out, it's the discussion and what you learn that's important, not the points.

    John

    Says you! You can buy tons of things...

  • RE: Know Your SQL Objects

    John Mitchell-245523 (5/13/2011)


    Koen Verbeeck (5/13/2011)


    Nils Gustav Stråbø (5/13/2011)


    "-Extents can be owned by only one object"

    False, since they can be a mixed extent (or even an extent that has not been...

  • RE: Know Your SQL Objects

    All... Straight from the BOL on my system:

    Page type -- Contents

    Data --

    Data rows with all data, except text, ntext, image, nvarchar(max), varchar(max), varbinary(max), and...

  • RE: Resource Governor Pools

    Steve - Another great question. I have used several CPU resource alocation products. They all require that the Min cpu for all groups adds up to 100% or...

Viewing 15 posts - 316 through 330 (of 673 total)