FTS Near Operator

  • Comments posted to this topic are about the item FTS Near Operator

  • Nice question..Thanks Steve!

    ~ Lokesh Vij


    Guidelines for quicker answers on T-SQL question[/url]
    Guidelines for answers on Performance questions

    Link to my Blog Post --> www.SQLPathy.com[/url]

    Follow me @Twitter

  • Lokesh Vij (7/24/2013)


    Nice question..Thanks Steve!

    +1 🙂

    Thanks
    Vinay Kumar
    -----------------------------------------------------------------
    Keep Learning - Keep Growing !!!

  • Great question. Never use full text search though, so definately learned something.

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

  • This was removed by the editor as SPAM

  • I was caught out by words like "the", "to" etc... which I thought would not be counted by near given that common words like those are generally not considered by fulltext searches.

  • Great question, thanks.

    I really like full-text indexing, but have only had a chance to use it a couple of time in production.

    Still managed to get it wrong though, due to an "epic fail" in reading comprehension (I clicked 3 answers instead of 2 after forgetting which two words I was supposed to be looking at).

  • Nice one....

  • Nice question

    Thanks

    Igor Micev,My blog: www.igormicev.com

  • peter.row (7/25/2013)


    I was caught out by words like "the", "to" etc... which I thought would not be counted by near given that common words like those are generally not considered by fulltext searches.

    Given that the default for NEAR is that word order doesn't count and the search term didn't force order to be considered, ignoring trivial words would have led to all four phrases matching; but the question stated that only two would match, which meant that the trivial words must count. So being caught out like that was somewhat careless of you. :hehe:

    Tom

  • Thanks for the question Steve! Definitely learned something today.



    Everything is awesome!

  • So not my area of expertise. Can't believe I got it right.

  • Certainly out of the beaten path. Thanks, Steve!

  • Good question Steve.

    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

  • I've never used FTS so I was pleasantly surprised to get this right. Thanks for the question Steve.

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

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