Post reply

Object_Id 1

  • 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]

  • February 22, 2012 at 10:01 pm

    #1450645

    Thanks for the easy question. 😀

  • February 23, 2012 at 1:28 am

    #1450679

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

  • February 23, 2012 at 1:57 am

    #1450691

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

  • February 23, 2012 at 2:29 am

    #1450705

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

  • February 23, 2012 at 2:52 am

    #1450715

    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.

  • February 23, 2012 at 6:28 am

    #1450801

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

    http://brittcluff.blogspot.com/

  • February 23, 2012 at 7:01 am

    #1450824

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

    Paul White
    SQLPerformance.com
    SQLkiwi blog
    @SQL_Kiwi

  • February 23, 2012 at 7:23 am

    #1450846

    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!

  • February 23, 2012 at 7:36 am

    #1450858

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

  • February 23, 2012 at 8:16 am

    #1450894

    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

  • February 23, 2012 at 8:23 am

    #1450902

    SQL Kiwi (2/23/2012)

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

    +1

  • February 23, 2012 at 8:57 am

    #1450926

    Needed a simple one today. Thanks for the question.

  • February 23, 2012 at 9:09 am

    #1450938

    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

  • February 23, 2012 at 9:14 am

    #1450947

    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]

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

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