Tips for using full-text search in SQL Server 2017 Make full-text index population during periods of low database access. Because full-text index population takes some time, these updates should be scheduled during CPU idle time and slow production periods. Reduce the full-text unique key size. To create a full-text index, the table to be indexed must have a unique index....
Troubleshooting SQL Server 2016 full-text search
Troubleshooting SQL Server 2016 full-text search If you have problems with SQL Server 2016 full-text search, review this troubleshooting checklist to find potential solutions. 1. Install the latest SQL Server 2016 service pack. Because some SQL Server 2016 full-text search bugs were fixed in SQL Server service packs, you should install the latest SQL Server service pack. At the time...