Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
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: Monday, January 25, 2016 9:55 AM
Points: 2,195, Visits: 1,652
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: Thursday, February 4, 2016 1:49 PM
Points: 4,915, Visits: 3,977
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, February 5, 2016 2:55 PM
Points: 19,580, Visits: 17,831
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, February 5, 2016 10:18 AM
Points: 3,865, Visits: 2,214
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: Thursday, January 28, 2016 7:39 AM
Points: 554, Visits: 461
Thanks Steve, nice one!
Post #1477988
Posted Friday, July 26, 2013 7:06 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Wednesday, February 3, 2016 11:57 AM
Points: 2,077, Visits: 611
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, February 4, 2016 4:38 AM
Points: 3,605, Visits: 2,744
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: Thursday, January 14, 2016 10:55 AM
Points: 361, Visits: 438
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: Tuesday, January 26, 2016 9:10 AM
Points: 2,601, Visits: 1,694
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