Object_Id 1

Question

Post reply

Object_Id 1

Ron McCullough

SSC Guru

Points: 63877
More actions
February 22, 2012 at 9:02 pm

#391628

Comments posted to this topic are about the item Object_Id 1
If everything seems to be going well, you have obviously overlooked something.
Ron

Please help us, help you -before posting a question please read[/url]
Before posting a performance problem please read[/url]

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

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

Kameswari Aravindh SSCrazy Points: 2380 More actions · Answer 1

Kameswari Aravindh

SSCrazy

Points: 2380

February 22, 2012 at 10:01 pm

#1450645

Thanks for the easy question. 😀

paul.knibbs SSCoach Points: 15320 More actions · Answer 2

Does the collation actually make a difference here, or was that included as a bit of misdirection?

palotaiarpad SSCertifiable Points: 5617 More actions · Answer 3

But there is a documentation that it must be uppercase: ms179899 🙂

Michael Riemer SSCertifiable Points: 5190 More actions · Answer 4

Thanks for the easy question - nice to check the basics again.

Raghavendra Mudugal SSChampion Points: 10658 More actions · Answer 5

YAY!!!. I got one point.

(representation of N - has nothing to do with the collation)

ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.

Britt Cluff SSCertifiable Points: 5083 More actions · Answer 6

Made me think for a minute and I got my point. Thanks for submitting.

http://brittcluff.blogspot.com/

Paul White SSC Guru Points: 150467 More actions · Answer 7

And once again I fail as a T-SQL parser.

Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi

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

good question!

thanks!

[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!

BarbW SSCarpal Tunnel Points: 4759 More actions · Answer 9

Good syntax question; not sure why collation info was included. Thanks!

TomThomson SSC Guru Points: 104773 More actions · Answer 10

Nice easy question, nice straightforward answer and explanation.

I guess that particular collation was chosen to demonstrate that not all T-SQL is case insensitive even when the collation is ..._CI_.. ?

Tom

OzYbOi d(-_-)b SSCarpal Tunnel Points: 4054 More actions · Answer 11

SQL Kiwi (2/23/2012)
And once again I fail as a T-SQL parser.

+1

DBA_Dom SSCrazy Points: 2902 More actions · Answer 12

Needed a simple one today. Thanks for the question.

SQLRNNR SSC Guru Points: 281334 More actions · Answer 13

EZ PZ lemon SQeZ

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

Ron McCullough SSC Guru Points: 63877 More actions · Answer 14

L' Eomot Inversé (2/23/2012)
Nice easy question, nice straightforward answer and explanation.
I guess that particular collation was chosen to demonstrate that not all T-SQL is case insensitive even when the collation is ..._CI_.. ?

Your absolutely correct, and since QOD can be / or is a teaching tool for some I felt it was a little plus item to show

If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read[/url]
Before posting a performance problem please read[/url]