Tips for using full-text search in SQL Server 2014 Reduce the full-text unique key size. To create a full-text index, the table to be indexed must have a unique index. Try to select a numeric column as the full-text unique key to increase the speed of full-text population. If the table to be indexed does not have numeric unique index,…