Stretch Database Datatype Limitations

  • Hi,

    Please check the question. I select all three options, but get the message incorrect response.

  • Rune Bivrin (6/29/2016)


    Steve has too much on his hands.

    +1

    The question is interesting, the typos I don't mind, at least I learned

    again something new. Documentation is at a good level. Thanks, Steve 😉

  • Good question bad answer 2 != 3

  • Reminds me of an old teacher of mine. They would purposefully mark a multiple-choice answer on a test as incorrect, so that you'd have to explain to them why the answer was the correct one in order to receive proper credit.

  • Got told I was wrong again for the right answer. +1

  • Steve, I think this QotD was rather poorly worded. You should reconsider the 'wrong' replies.

  • Obviously a case of the hierarchyid option not being checked in the official answers. :Whistling:

    Thanks Steve for the question about a new feature.

    JDBA

  • Arrggghhhh, my idiocy here. I didn't check the box for HierarchyID.

    Points awarded back.

    My apologies.

  • Steve Jones - SSC Editor (6/29/2016)


    Arrggghhhh, my idiocy here. I didn't check the box for HierarchyID.

    Points awarded back.

    My apologies.

    No, idiocy is not yours here.

    Yours is a simple mistake, a typo.

    Idiocy is of those who have already "proved" here how the mistake was a correct answer.

  • Sergiy (6/29/2016)


    Steve Jones - SSC Editor (6/29/2016)


    Arrggghhhh, my idiocy here. I didn't check the box for HierarchyID.

    Points awarded back.

    My apologies.

    No, idiocy is not yours here.

    Yours is a simple mistake, a typo.

    Idiocy is of those who have already "proved" here how the mistake was a correct answer.

    Well said, Sergyi.

  • Easy question, which I got wrong by not noticing "select 3" and just picking the first obvious exclusion. The square boxes should have stopped me clicking submit but I only noticed them (are started cursing) after my finger had started moving and didn't react fast enough.

    Stupid careless me! :doze::blush::ermm:

    Tom

  • Per the link : "http://www.sqlshack.com/the-dbas-guide-to-stretch-database/"

    Below are the data types which are not supported:

    filestream

    timestamp

    sql_variant

    XML

    geometry

    geography

    hierarchyid

    CLR user-defined types (UDTs)

    -- Considering this I was thinking why not "dateoffset", in place of text/image?

    Thanks.

  • SQL-DBA-01 (7/3/2016)


    Per the link : "http://www.sqlshack.com/the-dbas-guide-to-stretch-database/"

    Below are the data types which are not supported:

    filestream

    timestamp

    sql_variant

    XML

    geometry

    geography

    hierarchyid

    CLR user-defined types (UDTs)

    -- Considering this I was thinking why not "dateoffset", in place of text/image?

    Apparently, the list in the article is not correct.

    Unfortunately, factual errors are quite common in IT related publications.

    I even once won a bet that I'll find a false statement in any of books published by MS.

    So, - do not trust strangers from Internet!

    Even when they carry some heavy medals of honour.

  • I like the question and I even answered late enough that the tick 3 was not an issue. I do like that the text option was included.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

Viewing 14 posts - 16 through 29 (of 29 total)

You must be logged in to reply to this topic. Login to reply