Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 123»»»

FTS Near Operator Expand / Collapse
Author
Message
Posted Wednesday, July 24, 2013 9:49 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: 2 days ago @ 12:34 PM
Points: 31,181, Visits: 15,626
Comments posted to this topic are about the item FTS Near Operator






Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1477335
Posted Wednesday, July 24, 2013 10:51 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, October 16, 2014 10:02 AM
Points: 1,372, Visits: 1,566
Nice question..Thanks Steve!

~ Lokesh Vij

Guidelines for quicker answers on T-SQL question
Guidelines for answers on Performance questions

Link to my Blog Post --> www.SQLPathy.com

Follow me @Twitter

Post #1477338
Posted Wednesday, July 24, 2013 11:06 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, February 6, 2014 4:15 AM
Points: 1,242, Visits: 1,546
Lokesh Vij (7/24/2013)
Nice question..Thanks Steve!


+1




Thanks
Vinay Kumar
-----------------------------------------------------------------
Keep Learning - Keep Growing !!!
www.GrowWithSql.com

Post #1477340
Posted Thursday, July 25, 2013 1:25 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 11:42 AM
Points: 13,295, Visits: 11,086
Great question. Never use full text search though, so definately learned something.



How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1477354
Posted Thursday, July 25, 2013 2:04 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 10:32 AM
Points: 4,023, Visits: 5,323
Good question, thanks Steve.
haven't used full text since SQL 2000.....


____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”
Post #1477381
Posted Thursday, July 25, 2013 2:15 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, October 14, 2014 4:52 AM
Points: 223, Visits: 278
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.
Post #1477389
Posted Thursday, July 25, 2013 3:03 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Tuesday, October 21, 2014 6:56 AM
Points: 3,352, Visits: 1,487
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).
Post #1477403
Posted Thursday, July 25, 2013 3:24 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Monday, October 20, 2014 3:10 AM
Points: 856, Visits: 163
Nice one....
Post #1477410
Posted Thursday, July 25, 2013 3:44 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Yesterday @ 7:01 AM
Points: 3,014, Visits: 3,101
Nice question
Thanks




Igor Micev,
SQL Server developer at Seavus
www.seavus.com
Post #1477413
Posted Thursday, July 25, 2013 6:48 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 3:02 PM
Points: 7,801, Visits: 9,553
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.


Tom
Post #1477461
« Prev Topic | Next Topic »

Add to briefcase 123»»»

Permissions Expand / Collapse