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: Thursday, September 22, 2016 12:12 PM
Points: 2,204, Visits: 1,671
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


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 1:50 PM
Points: 5,330, Visits: 4,499
Certainly out of the beaten path. Thanks, Steve!
Post #1477764
Posted Thursday, July 25, 2013 3:38 PM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Friday, September 23, 2016 10:17 PM
Points: 20,008, Visits: 18,244
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


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 10:22 AM
Points: 4,075, Visits: 2,293
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: Monday, February 29, 2016 9:46 AM
Points: 555, Visits: 465
Thanks Steve, nice one!
Post #1477988
Posted Friday, July 26, 2013 7:06 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Tuesday, March 8, 2016 10:23 AM
Points: 2,144, Visits: 613
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: Monday, May 23, 2016 5:31 AM
Points: 3,615, Visits: 2,774
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: Tuesday, September 6, 2016 1:49 PM
Points: 361, Visits: 443
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,602, 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