FTS Near Operator

Question

Post reply

FTS Near Operator

Steve Jones - SSC Editor

SSC Guru

Points: 736173
More actions
July 24, 2013 at 9:49 pm

#275574

Comments posted to this topic are about the item FTS Near Operator
July 25, 2013 at 2:04 am

This was removed by the editor as SPAM

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

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

Lokesh Vij SSChampion Points: 10836 More actions · Answer 1

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

Vinay Kumar SSCertifiable Points: 6099 More actions · Answer 2

Lokesh Vij (7/24/2013)
Nice question..Thanks Steve!

+1 🙂

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

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

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

peter.row SSCarpal Tunnel Points: 4319 More actions · Answer 4

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.

Duncan Pryde SSCertifiable Points: 7956 More actions · Answer 5

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).

Bangla Hall of Fame Points: 3137 More actions · Answer 6

Bangla

Hall of Fame

Points: 3137

July 25, 2013 at 3:24 am

#1635647

Nice one....

Igor Micev SSC-Dedicated Points: 33109 More actions · Answer 7

Nice question

Thanks

Igor Micev,My blog: www.igormicev.com

TomThomson SSC Guru Points: 104773 More actions · Answer 8

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

Dana Medley SSCertifiable Points: 6764 More actions · Answer 9

Thanks for the question Steve! Definitely learned something today.

Everything is awesome!

sneumersky SSCertifiable Points: 7667 More actions · Answer 10

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

Revenant SSC-Forever Points: 42467 More actions · Answer 11

Revenant

SSC-Forever

Points: 42467

July 25, 2013 at 3:29 pm

#1635948

Certainly out of the beaten path. Thanks, Steve!

SQLRNNR SSC Guru Points: 281334 More actions · Answer 12

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

Ken SSCoach Points: 17191 More actions · Answer 13

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