Can a AWS PostgresSQL RDS instance be provided with a stop words file?
I need to provide a custom list of stop words. From the manual section on dictionaries the way to do this is to … Read more
full-text-search
How to make a FULLTEXT search with ORDER BY fast?
I’m trying to get a simple FULLTEXT match to be faster when using order by on another column on a table with over … Read more
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 … Read more
SQL 2008, how does it link Full Text Catalog to a filegroup
While creating Full Text Catalog, if “on filegroup” is specified – it creates the catalog on this file, but on MSDN I read … Read more
Can I get similar Full Text Search functionality without using Full-Text Search?
Normally, I wouldn’t post this kind of question here, but I can’t seem to find anyone who has actually used SQL Server Full … Read more
FullTextSearch indexing/searching words with special characters
I’m trying to query FullTextSearch indexed column for hashtags SELECT Bio FROM Users WHERE CONTAINS (Bio,’promoter’) SELECT Bio FROM Users WHERE CONTAINS (Bio,’#promoter’) … Read more
How we can do full text search and facets stuffs on BigQuery?
In the future, we will have millions ofs record in our web product. So we had used BigQuery for data storage and analysis. … Read more
When might a tsvector field pay for itself?
I’ve been experimenting with tsvector indexes for Full Text Search, and see that it’s a common practice to generate an store a vector … Read more
How to match all words of one column against words in another column
I have two tables. Table A: Company_name ——————————- Tata consultancy Infosys tech Atm service Air force firm Table B: Company1_name | Id ——————————– … Read more
Find records with same string with extra character
OK, so I have a Microsoft SQL Server 2014 database table called owner with around 90,000 records with owner information, another called vehicle … Read more
