LOB Data

  • Rune Bivrin (3/11/2011)


    This question is just completely broken. There's a big difference between "preferred" and "valid". And to claim that varbinary(max) isn't a LOB is a bit daft.

    QFT. Not to mention that it says "Select all that apply" and then gives you radio buttons, so you know it's only expecting one right answer...you just have to figure out which of the multiple possible right answers is the one it's looking for!

  • When we are to told to "Select all that apply" that means we are suppose to select all the correct answers. Hence providing radio buttons is not correct. Instead check boxes should have been provided.

    OR the question should have said "Select any one of the correct answer" with radio buttons provided for answers.

  • Rant!!!!!!!

    Ok I'm done :hehe:.

  • Relax, it's Friday, even for questions 😀

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • Koen Verbeeck (3/11/2011)


    Relax, it's Friday, even for questions 😀

    Exactly. So, anyone doing anything interesting this weekend?

    😎

  • Duncan Pryde (3/11/2011)


    Koen Verbeeck (3/11/2011)


    Relax, it's Friday, even for questions 😀

    Exactly. So, anyone doing anything interesting this weekend?

    😎

    Taking my motorcycle out for the first ride after the winter. 🙂

    -Michael

    BTW: Had the same issue with the radio buttons--so not sure how one was able to win the point anyway, as the 'correct answer' listed more than one data type...

  • Taking my fiancee out for her birthday 🙂

  • Wow, sounds like you're all having some fun this weekend!

    I'm having the in-laws to stay, and taking some junk to the tip. Lucky me!

  • Working on demos and presentation for 24 hours of pass. Weekend, what weekend?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • As already highlighted, Radio buttons and select all that apply don't kinda go together.

    Hence I had a thought maybe "NOT" was missing from the question... so selected "Spatial"... should have left it on varchar(max)!

    Poo... 🙁

    _____________________________________________________________________
    [font="Comic Sans MS"]"The difficult tasks we do immediately, the impossible takes a little longer"[/font]

  • Just a poorly worded question.. Poor choice for selection type and to me just a plain wrong answer.

  • select all that apply

    and

    radio buttons...

    LMAO...too funny

    I guess its done intentionally...lol

    Regards,

    Sushant

    Regards
    Sushant Kumar

  • Guys I think we should close on this now.

    All of us are coming up with the same point that it is the issue of framing the question.

    If anyone is sharing some knowledge that would be great for all of us.

    I hope u all don't mind.

    With Best Regards

    🙂

  • I found this question to be very subjective, even the reference listed did not make a preferable option but listed them. If my data is in xml format then xml is preferred so .query .nodes can be used to interrogate the data.

  • stewartc-708166 (3/11/2011)


    The options listed are classified as Large-Value data types, not LOB's

    refer:

    SQL2005: http://msdn.microsoft.com/en-us/library/ms178158(v=SQL.90).aspx

    SQL2008: http://msdn.microsoft.com/en-us/library/ms178158(v=SQL.100).aspx

    SQL2008R2: http://msdn.microsoft.com/en-us/library/ms178158(v=SQL.105).aspx

    And yet this:

    http://msdn.microsoft.com/en-us/library/ms187752.aspx

    In SQL Server, based on their storage characteristics, some data types are designated as belonging to the following groups:

    Large value data types: varchar(max), nvarchar(max), and varbinary(max)

    Large object data types: text, ntext, image, varchar(max), nvarchar(max), varbinary(max), and xml

    From the above one can conclude that varchat(max), nvarchar(max) and varbinary(max) are classified as being both. I guess we must have a data class known as chameleon except instead of changing color it changes what group it belongs to? ? ?

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

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

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