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.
| 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 ... REORGANIZERegardsViggneshwar A |
 |
|
|
|
|
|
RANK vs Prefix Searches