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 @ 4:16 PM
Points: 31,018, Visits: 15,456
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: Thursday, September 18, 2014 10:01 PM
Points: 1,287, Visits: 1,122
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: Thursday, September 18, 2014 1:36 PM
Points: 6,002, Visits: 8,267
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: 2 days ago @ 8:29 AM
Points: 12,945, Visits: 10,716
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: Wednesday, September 17, 2014 12:53 AM
Points: 2,529, Visits: 2,402
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: Friday, July 4, 2014 9:03 AM
Points: 1,415, Visits: 796
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: 2 days ago @ 12:00 AM
Points: 1,778, Visits: 488
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: 2 days ago @ 3:41 AM
Points: 1,699, Visits: 1,116
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: 2 days ago @ 8:29 AM
Points: 12,945, Visits: 10,716
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: Today @ 4:25 PM
Points: 7,688, Visits: 9,413
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