Stack Overflow
Stack Overflow

Questions tagged [freetexttable]

Is a function used in the FROM clause of a Transact-SQL SELECT statement to perform a SQL Server full-text search on full-text indexed columns containing character-based data types.

Is a function used in the FROM clause of a Transact-SQL SELECT statement to perform a SQL Server full-text search on full-text indexed columns containing character-based data types. This function returns a table of zero, one, or more rows for those columns containing values that match the meaning and not just the exact wording, of the text in the specified freetext_string. FREETEXTTABLE is referenced as if it were a regular table name.

43 questions
7
votes
2 answers

FREETEXTTABLE always has a rank of 0

I'm using SQLServer 2008 and if I perform the following query: SELECT * FROM FREETEXTTABLE(SomeTable, Name, 'a name that I know exists') I get the rows back that I would expect, but the rank is always 0. Searching for a solution to this…
s1mm0t
  • 6,035
  • 4
  • 38
  • 45
5
votes
1 answer

CROSS APPLY a FREETEXTTABLE

MS SQL Server 2005: table1 has a full text index. I want to run multiple freetexttable searches against it in a single query, but the two attempts i have fail. any help would be appreciated, thanks! p.s. am willing to upgrade to sql 2008 if it…
user433342
  • 859
  • 1
  • 7
  • 26
4
votes
1 answer

Ignore Dash (-) from Full Text Search (FREETEXTTABLE) search column in SQL Server

I use CONTAINSTABLE for my searching algorithm. I want to search column value with ignoring dash in particular column value. for example, column contains '12345-67' then it should search with '1234567' as below query. SELECT * FROM table1 AS…
SanketS
  • 963
  • 1
  • 13
  • 36
3
votes
1 answer

SQL Server FREETEXTTABLE not returning result

I have used SQL Server FREETEXTTABLE function to search in a table column based on the user entered words like a search engine and return best matching rows. Table column will contain many questions and user will type something in textbox (in any…
Hiren Khatri
  • 41
  • 6
3
votes
2 answers

Search a full text index for 'c#'

I have a table (lets say it has one column called 'colLanguage') that contains a list of skills and has a full text index defined on it. One of the entries in the table is 'c#' but when I search for 'c#' (using the following SQL) I get no results…
Keith K
  • 2,893
  • 4
  • 33
  • 43
3
votes
1 answer

FreeTextTable bad performance with SQL Server 2008

My index is populated with 12 millions of rows from DatasSearch_fr table Fields are : [Id] [int] IDENTITY(1,1) NOT NULL, [Data] [nvarchar](max) NOT NULL, [DataId] [varchar](200) NOT NULL, [DataTypeId] [int] NOT NULL By using FREETEXTTABLE like…
Sébastien.B
  • 31
  • 3
3
votes
2 answers

How to optimize a SQL Server full text search

I want to use fulltextsearch for an autocomplete service, which means I need it to work fast! Up to two seconds max. The search results are drawn from different tables and so I created a view that joins them together. The SQL function that I'm using…
Aha
  • 31
  • 1
  • 3
2
votes
1 answer

Slow inital query when using FreeTextTable in SQL Server 2005

The following FreeTextTable query takes > 10 seconds on the first request, but about a second for subsequent requests: SELECT [Key], [Rank] INTO #matches FROM FREETEXTTABLE(Book, [Description], @searchWord) After approx. 10 minutes of inactivity…
user97280
  • 75
  • 3
2
votes
1 answer

issue with MSSQL fulltext search

original table contains json, but i've stripped it down to the table below: id json 1 "name":"one.it.two" 2 "name": "one.it.two" difference between the two rows is the space after : catalog has no stopwords. searching for CONTAINS…
hmad
  • 159
  • 8
2
votes
1 answer

SQL Server ranking weirdness using FREETEXTTABLE across multiple columns

I have been struggling to get my head around how SQL Server full text search ranks my results. Consider the following FREETEXTTABLE search: DECLARE @SearchTerm varchar(55) = 'Peter Alex' SELECT ftt.[RANK], v.* FROM FREETEXTTABLE (vMembersFTS,…
Kaine
  • 521
  • 1
  • 4
  • 12
2
votes
3 answers

Why or How does FREETEXTTABLE give a rank value higher than others

There is a store procedure that uses FREETEXTTABLE twice on two tables and then merges the results and returns the top 50. The problem is if I do a search on "Women of Brewster", the results returns "Confession of an ex doofus motha" with a rank of…
avgbody
  • 1,382
  • 3
  • 15
  • 31
1
vote
1 answer

FREETEXTTABLE Returning Incorrect Rank Result

I'm trying to fix a bug with a site search function and have isolated it down to an issue with the FREETEXTTABLE function. I have a the following query: SELECT * FROM dbo.SiteContentForSearch INNER JOIN FREETEXTTABLE(SiteContentForSearch,…
CountZero
  • 6,171
  • 3
  • 46
  • 59
1
vote
0 answers

SQL to EF Core linq query (FREETEXTTABLE, joins, Ranking)

I'm new to using SQL server free text indexes. I've written a query that I'd like to convert to EF Core Linq query. I'm not if it possible or not (if not I'll create a stored procedure), but ideally I'd like to construct it in C# as a few other…
IeuanW
  • 228
  • 1
  • 9
  • 25
1
vote
1 answer

SQL Server Freetext Varbinary returns nothing and Conversion VARBINARY -> VARCHAR Not working

Hey I've a few issues with my solution and I can't figure it out Below is my creation table CREATE TABLE FreeTextSearch ( [ID] BIGINT NOT NULL IDENTITY(1,1), [Content] VARBINARY(MAX) NOT NULL, [SubjectClass] VARCHAR(30) NOT NULL, …
VoidEssy
  • 23
  • 7
1
vote
2 answers

SQL Server Query Some time take too much time with freetexttable - Looks Index Problem

Following is my query, it takes some time around 1 minute and some times gives a result in a second, problem occurred specially i execute query after some time ago, or put some new keyword in query. It looks like some index problem, when i executed…
Vkalal
  • 36
  • 3
1
2 3