Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
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 @ 11:16 AM
Points: 33,526, Visits: 17,660
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: Tuesday, March 8, 2016 7:00 AM
Points: 1,366, Visits: 1,212
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 @ 7:50 AM
Points: 7,602, Visits: 10,414
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


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 1:15 AM
Points: 15,143, Visits: 13,030
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 SQLKover.

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


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: 2 days ago @ 2:03 AM
Points: 3,138, Visits: 3,011
New features are welcome!
But, I get it wrong!
Post #1274084
Posted Wednesday, March 28, 2012 1:55 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 8:55 AM
Points: 1,582, Visits: 941
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
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 1:04 AM
Points: 2,382, Visits: 591
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


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 9:23 AM
Points: 2,425, Visits: 1,618
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


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 1:15 AM
Points: 15,143, Visits: 13,030
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 SQLKover.

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 @ 8:32 AM
Points: 9,342, Visits: 11,297
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