All Questions
Tagged with full-text-search t-sql
13 questions
1
vote
2
answers
1k
views
How can I tell if a full-text index is being used?
It's possible to tell how much a rowstore index is used, but what about full-text?
I could find nothing in any GUI or DMV. Even dbatools doesn't support it.
I've inherited a server that has a few full-...
- 801
4
votes
2
answers
1k
views
Is there a way stop the "." (period) acting as a word breaker in FullText Indexes?
I know the period is a word breaker however I want to be able to search the fulltext catalog for a field containing the phrase "ASP.Net" or similar.
Currently my search returns 'ASP' and 'Net' without ...
- 81
3
votes
2
answers
5k
views
Full text search using words stored in another table
Is there a way to do a full-text search using words stored in another table? This is my scenario:
Table_A contains phrases entered by users in field "UserInput" (and other stuff). I have a full-...
- 161
1
vote
1
answer
1k
views
FULLTEXT CONTAINS search returns no results in SQL SERVER 2014 with multiple search terms
When I try to use multiple search terms in a CONTAINS clause I get no results.
SELECT *
FROM dbo.Address
WHERE CONTAINS([Address].*,'"Detroit"') AND CONTAINS([Address].*,'"48226"')
OPTION(...
- 95
0
votes
1
answer
408
views
T-SQL Fulltext search by first word
How can I perform "starts with" logic with full text search?
For example there is a Contains logic :
WHERE contains(Note,' "*word*" ')
I guess I need search by first word in the string, but how can ...
- 241
3
votes
1
answer
389
views
FreeTextTable - Query as a set operation vs. having to cursor
Does anyone know if it is possible to join to a free text table to query for many search terms in one operation vs. having to cursor over?
For example if I have a function that gets the top 1 closest ...
- 311
3
votes
2
answers
1k
views
How can I perform a full-text CONTAINS call across a list of phrases?
I have a list of words/phrases in a table phrases. I have another table with a full-text catalog indexing the description column.
I want to populate a table results with a record for each phrase, and ...
- 352
1
vote
0
answers
74
views
Can I Parse and/or include "And" in my SQL Statement for a full text index?
So I have a query that looks at a full text index like this:
SELECT *
FROM Table1 q
INNER JOIN CONTAINSTABLE(Table1,TableField, @Keywords) search
ON q.Key = search.[KEY]
Now @Keywords can ...
- 145
0
votes
1
answer
8k
views
Keyword Search a single SQL Server table for multiple search terms and create a new table from results?
I am not a database administrator. Most of my experience is with MySQL. However I think what I want to do is in the realm of possibility.
I want to text query a single large table in a SQL Server ...
- 153
2
votes
1
answer
1k
views
SQL Server Full-Text Search: combining proximity term and thesaurus
Scenario
I am developing a full-text search over a products table.
The full-text indexed field of th table contains a brief description of the product, the name of the category and the product code.
...
- 359
0
votes
1
answer
2k
views
Searching for keywords in fulltext indexes using the "contains" function
Lets assume "and" is not a stopword, in my language it should not be.
How do I search for it using the contains function?
It is a keyword, but how do I escape the keywordness?
No luck with:
SELECT ...
- 664
4
votes
2
answers
556
views
Fulltext search limiting users possibilities
We have a web site with a search box. The search uses a fulltext index column. However, we just cant feed the text the user has input into this stored procedure.
CREATE PROCEDURE [dbo].[SearchPages]
...
- 664
1
vote
1
answer
4k
views
SQL Server Full-Text Indexer with stoplists/stopwords
As I'm working on a graduate project (Textmining with SQL Server 2012 Semantic Search) I run into a situation where I need to post a question on this website, hoping someone can help me.
This ...
