Long running queries when using DISTINCT with Strings

  • you may want to try binary_checksum over the varchar(max) column!


    * Noel

  • Noel,

    I am a little confused!

    A checksum solution has already been posted.

    Binary checksum would be collation and case-sensitive! Not sure that is what the OP wants?

    Cheers,

    Paul

  • Paul White (4/6/2009)


    Noel,

    I am a little confused!

    A checksum solution has already been posted.

    Binary checksum would be collation and case-sensitive! Not sure that is what the OP wants?

    Cheers,

    Paul

    Hi Paul,

    You are correct. I should have taken a closer look at previous threads.


    * Noel

  • Hey Noel,

    No worries - I do it all the time, just making sure I wasn't missing something clever...

    🙂

    Paul

Viewing 4 posts - 31 through 33 (of 33 total)

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