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: Yesterday @ 11:24 AM
Points: 32,781, Visits: 14,942
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: Wednesday, April 02, 2014 9:27 PM
Points: 1,242, Visits: 1,097
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: Today @ 1:47 PM
Points: 5,795, Visits: 8,011
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 @ 4:35 AM
Points: 12,208, Visits: 9,172
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: 2 days ago @ 6:53 AM
Points: 2,393, Visits: 2,286
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, April 01, 2014 9:09 AM
Points: 1,337, Visits: 746
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: Thursday, April 10, 2014 1:38 AM
Points: 1,615, Visits: 446
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


UDP Broadcaster

UDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP Broadcaster

Group: General Forum Members
Last Login: Thursday, April 17, 2014 4:49 AM
Points: 1,491, Visits: 976
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 @ 4:35 AM
Points: 12,208, Visits: 9,172
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


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Today @ 9:56 AM
Points: 8,288, Visits: 8,739
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