Your search for "full-text-search" returned 100 results:
I have a table column contains English and French. My FTS always returns something unexpected. I am not sure because of the multi lingual or not. Can someone tell? Thanks
2013-04-18
891 reads
2008-10-06
789 reads
Hi, I am getting this error while executing procedure plz tell me solution to solve this
2010-10-24
1,111 reads
HiHaving issues with FTS.Installed 2017 on Server, RTM- CU9, Os is Windows Server 2016.The issue is that FTS is not updating.Have checked the log but nothing there indicates an issue.Pending changes just build up.Restarting the FTS does not help, neither does applying track changes or incremental population.Only repopulates after a SQL Engine restart.This is a primary […]
2019-03-05
126 reads
we are testing a new project and are trying to use Full Text search. We have a front end app that allows customer service staff to search for customers. They have the ability to search up to 10 different fields of data. (I.e. First name, Last name, Address, etc) We setup a Full Text index […]
2012-11-28
3,485 reads
2008-10-06
789 reads
I have been looking for info on how to monitor fragmentation levels of full-text-search (FTS) indexes on an ongoing basis, and came across this link below, that provides a helpful explanation: Basically, it suggests that the FTS index should be reorganized once the number of fragments per table reaches 30-50: Is this what people use? […]
2011-05-31
939 reads
Hi, I have the following full-text-search query: I'm looking for any occurences of string "AB-C-123456" followed by any sequence of characters. The problem is this does not work; returns no records. I know for a fact that I have occurences of "AB-C-123456" in the column. On the other hand, this works (returns 2 records): This […]
2011-05-31
234 reads
Hi, I am implementing full text search in our dB. I'm able to search .doc, .xls files but not .docx and .xlsx files. I've the latest filters pack (office 2010) installed on the server. Am I missing something in the set up?
2010-11-30
363 reads
Hi, Today morning I was informed that the Full text search is not working on one server. We have only one full text search on this server. I recreated the catalog and added the table again, but it still does not work. I tried creating a test table and create a full text search on […]
2010-09-21
52 reads
By Steve Jones
We’re taking the roadshow across the water. Hope the plane makes it. The Redgate...
SQL aggregate functions are your go-to tools for transforming raw data into actionable insights....
By Steve Jones
This month is a great topic to me. I think growing and improving your...
Have 2 instances on the same TestServer 1. Default 2014 Dev edition on port...
My company where I worked recently upgraded to SQL Server 2022 Enterprise and Querystore...
hi all, is there anyway in SQL to getting logged in user name to...
In which editions can I use Full-Text and semantic search?
See possible answers