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»»»

In Database We Trust Expand / Collapse
Author
Message
Posted Wednesday, February 19, 2014 8:55 PM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: Moderators
Last Login: Monday, November 17, 2014 2:20 PM
Points: 6,800, Visits: 1,914
Comments posted to this topic are about the item In Database We Trust

Andy
SQLAndy - My Blog!
Connect with me on LinkedIn
Follow me on Twitter
Post #1543316
Posted Wednesday, February 19, 2014 11:32 PM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 11:48 AM
Points: 17,948, Visits: 15,944
Definitely an interesting question.

It makes you think about the difference between a reserved keyword and just a keyword.




Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server, MVP


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Post #1543336
Posted Thursday, February 20, 2014 12:52 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Monday, October 27, 2014 10:59 PM
Points: 1,794, Visits: 777
Nice question, thanks.

Hope this helps...

Ford Fairlane
Rock and Roll Detective





Post #1543350
Posted Thursday, February 20, 2014 1:18 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 12:57 AM
Points: 2,587, Visits: 2,443
Good question!
Thanks!

create database DEFAULT_DATABASE

This runs!

create database DELETE

This DOESN'T run!
You can use reserved words that stand for OPTIONS!

Post #1543352
Posted Thursday, February 20, 2014 2:44 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: Today @ 8:49 AM
Points: 3,075, Visits: 3,188
Interesting question!
Only the SQL Server reserved keywords cannot be used directly as a database name, anything else can - http://technet.microsoft.com/en-us/library/ms189822.aspx
You can use [] , anyway.

Thanks




Igor Micev,
SQL Server developer at Seavus
www.seavus.com
Post #1543368
Posted Thursday, February 20, 2014 3:14 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Yesterday @ 2:07 AM
Points: 4,100, Visits: 5,456
SQLRNNR (2/19/2014)
Definitely an interesting question.

It makes you think about the difference between a reserved keyword and just a keyword.


+1


____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”
Post #1543380
Posted Thursday, February 20, 2014 6:16 AM
SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Yesterday @ 9:07 PM
Points: 4,453, Visits: 3,905
Stewart "Arturius" Campbell (2/20/2014)
SQLRNNR (2/19/2014)
Definitely an interesting question.

It makes you think about the difference between a reserved keyword and just a keyword.


+1

Yeah, it definitely made me think it through. Good question.



Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions
Post #1543447
Posted Thursday, February 20, 2014 7:20 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: 2 days ago @ 7:59 AM
Points: 330, Visits: 234
On multiple choice questions like this, it would be best if they did not say "(Select 2)", because four of the options will "use up" those two options: either the database is marked as trustworthy or it is not marked as trustworthy, and either the database will be set to read only or the database will not be set to read only. That means that the other two options must be false.

Aside from that minor suggestion, I do like this question, because it makes you think about which keywords are reserved and which are not (even though it's not a good idea to use a keyword for a database name), and it's interesting that a setting that is changed by ALTER DATABASE is not actually stored in the database.
Post #1543478
Posted Thursday, February 20, 2014 7:34 AM


SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Friday, November 14, 2014 2:26 PM
Points: 619, Visits: 387
stephen.long 56048 (2/20/2014)
On multiple choice questions like this, it would be best if they did not say "(Select 2)", because four of the options will "use up" those two options: either the database is marked as trustworthy or it is not marked as trustworthy, and either the database will be set to read only or the database will not be set to read only. That means that the other two options must be false.

Aside from that minor suggestion, I do like this question, because it makes you think about which keywords are reserved and which are not (even though it's not a good idea to use a keyword for a database name), and it's interesting that a setting that is changed by ALTER DATABASE is not actually stored in the database.


Oh man, that's true. I still learned something though.
Post #1543492
Posted Thursday, February 20, 2014 7:40 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: Moderators
Last Login: Monday, November 17, 2014 2:20 PM
Points: 6,800, Visits: 1,914
Stephen, I'll consider that for my next question!

Andy
SQLAndy - My Blog!
Connect with me on LinkedIn
Follow me on Twitter
Post #1543497
« Prev Topic | Next Topic »

Add to briefcase 123»»»

Permissions Expand / Collapse