Database Collation

Question

Database Collation

CoolCodeShare

SSCrazy

Points: 2584
More actions
September 10, 2011 at 3:09 pm

#243528

Comments posted to this topic are about the item Database Collation

Viewing 15 posts - 1 through 15 (of 32 total)

You must be logged in to reply to this topic. Login to reply

SQLRNNR SSC Guru Points: 281334 More actions · Answer 1

Nothing like an easy question to start the week.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

CoolCodeShare SSCrazy Points: 2584 More actions · Answer 2

Thanks Jason!

Yes, it is an easy question but as you know sometimes we opt to change case sensitivity and our codes become difficult to manage, so the point is nothing but to remind that something not right if you don't care about the proper casing.

Regards,

Sudhir

TomThomson SSC Guru Points: 104773 More actions · Answer 3

Good easy question.

I got it wrong because I am not case-sensitive when scanning SQL :blush::laugh:

Tom

Richard Warr SSCertifiable Points: 6966 More actions · Answer 4

45% incorrect answers would imply that it wasn't an easy question! Well done to those who knew the correct answer or, like me, guessed there would be a catch somewhere.

CoolCodeShare SSCrazy Points: 2584 More actions · Answer 5

@richard-2 Warr:

45% incorrect answers would imply that it wasn't an easy question! Well done to those who knew the correct answer or, like me, guessed there would be a catch somewhere.

Yes, I am surprised too. As the title -"Database Collation" itself is a big hint.

adb2303 SSCertifiable Points: 7588 More actions · Answer 6

I was lucky that I'd had a similar problem querying sys.partitions recently, and received an error due to the collation of the database (I had used a capital 'P' for partitions)

rfr.ferrari SSCertifiable Points: 6879 More actions · Answer 7

good question!

[font="Times New Roman"]rfr.ferrari[/font]
DBA - SQL Server 2008
MCITP | MCTS

remember is live or suffer twice!
the period you fastest growing is the most difficult period of your life!

Iulian -207023 SSCertifiable Points: 7639 More actions · Answer 8

I did not knew it is case sensitive.

Thank you for the question,

Iulian

Thomas Abraham SSChampion Points: 10761 More actions · Answer 9

Thanks for the question.

BTW, can anyone else see a question for October 14, 2011 in their list of "previous" questions?

[font="Verdana"]Please don't go. The drones need you. They look up to you.[/font]
Connect to me on LinkedIn

paul s-306273 SSChampion Points: 10730 More actions · Answer 10

Thomas Abraham (9/12/2011)
Thanks for the question.
BTW, can anyone else see a question for October 14, 2011 in their list of "previous" questions?

Yes - I can see it too!

Thomas Abraham SSChampion Points: 10761 More actions · Answer 11

paul s-306273 (9/12/2011)
Thomas Abraham (9/12/2011)
BTW, can anyone else see a question for October 14, 2011 in their list of "previous" questions?
Yes - I can see it too!

If he's going to put up questions a month in advance, the least Steve could do is make the query return that day's winning lottery numbers! :hehe:

[font="Verdana"]Please don't go. The drones need you. They look up to you.[/font]
Connect to me on LinkedIn

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 12

Nice question, thanks.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

cengland0 SSCertifiable Points: 6102 More actions · Answer 13

I got it right but for the wrong reason. The reason specified was for case sensitivity but I thought of other reasons it wouldn't run. The question said "always" but it wouldn't run under these situations either:

* Network issue

* Hard drive failure

* Failure to connect to the database

* Server being restored from backup at the time

There are many reasons it wouldn't run but once I thought of a single one, it made the statement false.

cengland0 SSCertifiable Points: 6102 More actions · Answer 14

paul s-306273 (9/12/2011)
Thomas Abraham (9/12/2011)
Thanks for the question.
BTW, can anyone else see a question for October 14, 2011 in their list of "previous" questions?
Yes - I can see it too!

You both have experienced a "Flash Forward"