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


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Friday, December 19, 2014 9:21 AM
Points: 1,991, Visits: 1,496
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: Friday, October 24, 2014 12:43 PM
Points: 4,126, Visits: 3,428
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: Friday, December 19, 2014 3:20 PM
Points: 18,064, Visits: 16,099
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: Thursday, December 18, 2014 10:56 AM
Points: 3,417, Visits: 2,035
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: Friday, December 12, 2014 6:22 AM
Points: 531, Visits: 449
Thanks Steve, nice one!
Post #1477988
Posted Friday, July 26, 2013 7:06 PM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Friday, December 19, 2014 11:55 AM
Points: 1,848, Visits: 590
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, November 20, 2014 4:29 AM
Points: 3,559, Visits: 2,671
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: Friday, December 19, 2014 8:05 AM
Points: 357, Visits: 384
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: Friday, December 19, 2014 12:50 PM
Points: 2,500, Visits: 1,586
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