Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2012 Forums
 Transact-SQL (2012)
 RANK vs Prefix Searches

Author  Topic 

Dingoace10
Starting Member

1 Post

Posted - 2014-10-08 : 16:20:40
Hello all,
We are using Full text searching with Rank and most of the time it works fine. Problem comes in when using the rank with a Prefix Search.
Most basic searches get bad results:
SELECT RANK FROM CONTAINSTABLE (<TableName>,alltext,'"ch*"')

(Obviously changing <TableName> to be an actual table name and "alltext" is a field)

Sometimes the rank for this search send back rank of 0. Point at a different table and some times the rank works fine.

I know the problem has to do with 2012 since I took a working 2005 db (ALL ranked searches work) and restored it on to a 2012 instances and the same searches stop working.

We have tried rebuilding the indexes, but that doesn't seem to affect any result.

Is there some sort of configuration setting that I am missing that was added to 2012? (BTW 2008r2 seems to have the same issues).

Thanks for the help!

viggneshwar
Yak Posting Veteran

86 Posts

Posted - 2015-01-08 : 10:01:33
ALTER FULLTEXT CATALOG ... REORGANIZE

Regards
Viggneshwar A
Go to Top of Page
   

- Advertisement -