Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 123»»»

Contained Databases Expand / Collapse
Author
Message
Posted Tuesday, March 27, 2012 9:51 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 12:41 PM
Points: 31,177, Visits: 15,618
Comments posted to this topic are about the item Contained Databases






Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1274035
Posted Tuesday, March 27, 2012 11:20 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Yesterday @ 9:26 PM
Points: 1,293, Visits: 1,127
Hi Steve,

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

Good. to knew about contained databases.

--Babu
Post #1274057
Posted Wednesday, March 28, 2012 12:32 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: 2 days ago @ 3:07 AM
Points: 6,040, Visits: 8,322
Good question - but what's up with the word "other" in the question?


Hugo Kornelis, SQL Server MVP
Visit my SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis
Post #1274078
Posted Wednesday, March 28, 2012 12:39 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 12:16 PM
Points: 13,253, Visits: 11,032
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




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1274080
Posted Wednesday, March 28, 2012 12:56 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 12:53 AM
Points: 2,559, Visits: 2,418
New features are welcome!
But, I get it wrong!
Post #1274084
Posted Wednesday, March 28, 2012 1:55 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, October 7, 2014 8:36 AM
Points: 1,415, Visits: 802
Bit of a strange question.

Two days running I've guessed.
Two days running I've guessed incorrectly.

Aarggh!
Post #1274111
Posted Wednesday, March 28, 2012 2:34 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Friday, October 17, 2014 1:15 AM
Points: 1,805, Visits: 496
Great to see questions on 2012 now, but also have to ask what is up with the "other" in the question?
Post #1274136
Posted Wednesday, March 28, 2012 2:47 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 2:14 AM
Points: 1,732, Visits: 1,142
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.
Post #1274143
Posted Wednesday, March 28, 2012 3:01 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 12:16 PM
Points: 13,253, Visits: 11,032
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!




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1274151
Posted Wednesday, March 28, 2012 5:00 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: 2 days ago @ 11:12 AM
Points: 7,791, Visits: 9,545
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
Post #1274192
« Prev Topic | Next Topic »

Add to briefcase 123»»»

Permissions Expand / Collapse