How do I assign different weights to columns in SQL Server Full Text Search?
- by gcaprio
I'm using SQL Server 2008 FTS and I'd like to be able to integrate weighted rankings into my search results. However, I'd like to weight the columns that a search term is found in differently. For example, if I have a Title column and a Description column, I want matches fond in Title to rank higher than matches in Description.
Is this possible in SQL Server 2008? As far as can I see, I can only add weights to specific terms, not column locations.