Contained Databases

  • Comments posted to this topic are about the item Contained Databases

  • Hi Steve,

    Question on SQL 2012. I guessed and guessed it wrong.

    Good. to knew about contained databases.

    --Babu

  • Good question - but what's up with the word "other" in the question?


    Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
    Visit my SQL Server blog: https://sqlserverfast.com/blog/
    SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/

  • Good to see questions on SQL Server 2012.

    I did find the question itself poorly phrased, because of the use of "other" and the general term "options".

    When I look at the reference, I see the following:

    contained, uncontained, partial, non-contained

    So it looks like there are more two correct answers, but there is no explanation given why some are correct and others aren't.

    edit: after reading the reference a few times, it makes more sense 😀

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

  • New features are welcome!

    But, I get it wrong!

    😛

  • Bit of a strange question.

    Two days running I've guessed.

    Two days running I've guessed incorrectly.

    Aarggh!

  • Great to see questions on 2012 now, but also have to ask what is up with the "other" in the question?

  • I kind of assumed the 'other' was a simple typo - the better reference I think is just to CREATE DATABASE:

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

    This clearly defines the options.

  • call.copse (3/28/2012)


    I kind of assumed the 'other' was a simple typo - the better reference I think is just to CREATE DATABASE:

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

    This clearly defines the options.

    That is indeed a very clear reference. Thanks!

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

  • Nice to see a question on sql 2012.

    But the wording could have been better. Like Koen and Hugo and call.copse I find that word "other" in the question bizarre. My first reaction was "other than what".

    Obviously "NONE" is not an option for a contained database: CONTAINMENT = NONE in CREATE DATABASE certainly doesn't generate a contained database! I guess the options concerning contained databases are "have a partially contained database" and "don't have a contained database", but the latter is certainly not an option for a contained database (one might of course label it an option against a contained database.

    After much cogitatin I decided the word "other" was meaningless and that "options for a contained database" must mean "options for the containment or otherwise of a database" since it certainly couldn't mean what it said, so I scored the point. But that was because I guessed right about what the question meant, not because the question said what it intended to mean.

    There were only 24% correct answers to date; it's quite possible that some of the other 76% were caused by the really strange wording of the question.

    Tom

  • Koen Verbeeck (3/28/2012)


    Good to see questions on SQL Server 2012.

    I did find the question itself poorly phrased, because of the use of "other" and the general term "options".

    When I look at the reference, I see the following:

    contained, uncontained, partial, non-contained

    So it looks like there are more two correct answers, but there is no explanation given why some are correct and others aren't.

    edit: after reading the reference a few times, it makes more sense 😀

    This was my understanding of the question as well. Judging by the QOTD responses and that most people answered incorrectly (as did I) the wording threw many of us off.

  • Yippee skippee.

    Let's have more questions on 2012

    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

  • ? on SQL 2012 +1

  • Got confused with the word "Other". Thought it was partial and uncontained!!!

  • Good question, but a little more wording on it would have helped understand what "other" means (options for creation, options for containment model, etc.)

    "El" Jerry.

    "El" Jerry.

    "A watt of Ottawa" - Gerardo Galvan

    To better understand your help request, please follow these best practices.[/url]

Viewing 15 posts - 1 through 15 (of 20 total)

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