score:2
The simple solution for me was to turn off the stop list using below script
ALTER FULLTEXT INDEX ON [tablename] Set StopList = OFF
I already have an index configured, which was using the default stoplist. I am turning off the stoplist here
score:3
You have created FULLTEXT index without specifying STOPLIST. Thus, the default STOPLIST was used. By default the word 'the' is the stop word, that removed from your text. If you want to search by word 'the' you should create an empty STOPLIST and then specify this STOPLIST in your FULLTEXT INDEX. The default stop words you can check by query:
SELECT *
FROM sys.fulltext_system_stopwords
WHERE language_id = 1033 -- English
Then you can create empty STOPLIST:
CREATE FULLTEXT STOPLIST MyEmptyStopList;
GO
Then set it into your FULLTEXT INDEX:
CREATE FULLTEXT INDEX ON table_name ... STOPLIST = MyEmptyStopList;
More questions
- SQL Azure CONTAINS not returning all results
- SQL Server Contains Full Text Function Not Returning Expected Results
- SQL Contains() not returning results for 'The'
- Transact SQL CONTAINS not returning match for identical strings with a wildcard
- SQL Server FOR XML query not returning results in expected hierarchy
- login failed for user 'sa'. The user is not associated with a trusted SQL Server connection. (Microsoft SQL Server, Error: 18452) in sql 2008
- Why is IS NOT NULL returning NULL values for a Varchar(max) in SQL Server?
- SQL Query for Grouping the results based on sequence
- Dynamic SQL not returning results in Access pass-through query
- A valid destination folder for the install could not be determined when installing SQL Server Management Studio 2016
- JTDS driver not working for Sql Server 2008R2 and Denali Native SSPI library not loaded. Check the java.library.path system property
- What can cause the SQL Server JDBC error 'The value is not set for the parameter number 0' for an output parameter access?
- Why does the FOR Clause not work with an alias in SQL Server 2016 with temporal tables?
- fatal error during installation (0x80070643) SQL Server MAnagement Studio: A valid destination folder for the install could not be determined
- Why do results from a SQL query not come back in the order I expect?
- Migrating to SQL Server in TeamCity: A driver for the source database not found
- EXCEPT SQL statement in SQL Server not returning expected results
- How do I update an XML column in sql server by checking for the value of two nodes including one which needs to do a contains (like) comparison
- Is SQL Server's Full Text Search the right tool for searching phrases, not documents?
- Can SQL return different results for two runs of the same query using ORDER BY?
- Like statement in SQL Server query not returning all results
- Not sure about the type of SQL Server lock to use for synchronization
- Error SQL71624: The permission 'CONNECT' is not valid for the target object 'guest' in Microsoft Azure SQL Database v12
- SQL Joins: Select status of reviews submitted by employees and also the list of employees who have not submitted the review for each year
- What can I use in a SQL query to help me determine why my query is not returning any data results
- Azure SQL DB publishing: Statement 'CREATE SYMMETRIC KEY' is not supported for the targeted platform
- SQL query design not returning expected results
- SqlException when the database is not started but SQL Server is ready for connections
- FOR XML could not serialize the data for node because it contains a character (0x0001) which is not allowed in XML
- SQL WHERE Like Clause not returning all results
More questions with similar tag
- SQL Server : Pivot Function Error
- Calling MSSQL stored procedure from SqlAlchemy
- use case to 'Name and Extension', 'Full Qualified' and 'Name Only' options in foreach file enumerator in ssis
- How to max(date) and use the in feature in sql server in one query?
- SQL: Find all records in Table A that do not have a value in Table B based on a column value in Table B
- Error while insert dataframe to Sql-server DB using to_sql function in python
- t-sql to create XML file using FOR XML Path, multilevel issues
- how to make trigger execute only when user directly affect table through SSMS. Not when stored procedures executes
- Could not find server in sys.servers. Verify that the correct server name was specified
- Is it possible to specify a SQL Server schema name in a Rails ActiveRecord migration?
- Split a delimited string into a table with multiple rows and columns
- procedure with multi where statement
- CASE STATEMENT for create view in SQL Server 2008
- Time based filtering using sql
- SQL Server Migration Assistant for MySQL - the connection has been disabled error
- List Enum String in HTML/PHP Dropdown with values from 2 MSSQL tables
- Remove duplicate sub-query
- Storing chat conversations in sql database using signalR
- Get total price and quantity of items sold with price changes
- SQL to return only previous full months
- SQL Server - How to Hint an Index on an Update command?
- ServiceStack OrmLite with multiple Database Servers
- SQL: Two similar queries into one query such that returns one table with two columns
- Get Master key Password in Sql Server
- SQL Server ISDATE() Function - Can someone explain this?
- How below two update statements are different in SQL?
- Checking Duplicate Records in Table Where Id is Identity
- SQL - How do I simplify this easy query?
- SQL Server 2005 DBA Learning Resource
- Batch delete data from SQL Server table