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 Thursday, July 25, 2013 7:49 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 7:11 AM
Points: 2,106, Visits: 1,567
Thanks for the question Steve! Definitely learned something today.



Everything is awesome!
Post #1477493
Posted Thursday, July 25, 2013 8:40 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, July 28, 2014 7:12 PM
Points: 2,148, Visits: 487
So not my area of expertise. Can't believe I got it right.
Post #1477533
Posted Thursday, July 25, 2013 3:29 PM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Yesterday @ 9:55 AM
Points: 4,384, Visits: 3,592
Certainly out of the beaten path. Thanks, Steve!
Post #1477764
Posted Thursday, July 25, 2013 3:38 PM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 1:42 AM
Points: 18,505, Visits: 16,751
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
Post #1477769
Posted Thursday, July 25, 2013 3:42 PM


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: Friday, April 17, 2015 9:35 AM
Points: 3,553, Visits: 2,081
I've never used FTS so I was pleasantly surprised to get this right. Thanks for the question Steve.
Post #1477772
Posted Friday, July 26, 2013 7:12 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Wednesday, December 31, 2014 9:45 AM
Points: 533, Visits: 450
Thanks Steve, nice one!
Post #1477988
Posted Friday, July 26, 2013 7:06 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, March 13, 2015 12:40 PM
Points: 2,070, Visits: 595
very good question..
Thanks Steve..
Post #1478254
Posted Tuesday, August 6, 2013 1:27 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: Thursday, April 16, 2015 4:48 AM
Points: 3,593, Visits: 2,687
Wonderful question. I have never worked on FTS. So in order to get the correct answer, I had to dig MS technet site and bingo. learned something new.
Post #1481186
Posted Tuesday, August 6, 2013 1:27 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, March 25, 2015 7:27 AM
Points: 361, Visits: 417
Very good question...We use FREETEXTTABLE instead of CONTAINSTABLE in our FTS table searches. Thought for sure that the 3 was characters and not words apart.

I always learn more when I get it wrong.

Anton



Post #1481519
Posted Thursday, August 8, 2013 5:41 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Wednesday, April 15, 2015 5:59 PM
Points: 2,584, Visits: 1,677
Koen Verbeeck (7/25/2013)
Great question. Never use full text search though, so definately learned something.


+1


Not all gray hairs are Dinosaurs!
Post #1482615
« Prev Topic | Next Topic »

Add to briefcase ««123»»

Permissions Expand / Collapse