Post reply

Contained Databases

  • March 27, 2012 at 9:51 pm

    #270919

    Comments posted to this topic are about the item Contained Databases

  • March 27, 2012 at 11:20 pm

    #1465462

    Hi Steve,

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

    Good. to knew about contained databases.

    --Babu

  • March 28, 2012 at 12:32 am

    #1465476

    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/

  • March 28, 2012 at 12:39 am

    #1465478

    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

  • March 28, 2012 at 12:56 am

    #1465482

    New features are welcome!

    But, I get it wrong!

    😛

  • March 28, 2012 at 1:55 am

    #1465506

    Bit of a strange question.

    Two days running I've guessed.

    Two days running I've guessed incorrectly.

    Aarggh!

  • March 28, 2012 at 2:34 am

    #1465528

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

  • March 28, 2012 at 2:47 am

    #1465534

    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.

  • March 28, 2012 at 3:01 am

    #1465542

    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

  • March 28, 2012 at 5:00 am

    #1465578

    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

  • March 28, 2012 at 7:40 am

    #1465663

    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.

  • March 28, 2012 at 8:07 am

    #1465694

    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

  • March 28, 2012 at 8:41 am

    #1465722

    ? on SQL 2012 +1

  • March 28, 2012 at 9:53 am

    #1465773

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

  • March 28, 2012 at 11:10 am

    #1465842

    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