Tag: full-text search

Pro Members SQL Server Standard Members

Tips for using full-text search in SQL Server 2019

by

Tips for using full-text search in SQL Server 2019 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....

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Log In Register
Continue Reading →
Pro Members SQL Server Standard Members

Troubleshooting SQL Server 2017 full-text search

by

Troubleshooting SQL Server 2017 full-text search If you have problems with SQL Server 2017 full-text search, review this troubleshooting checklist to find potential solutions. 1. Ensure the user needs to create, alter or drop the full-text catalogs have appropriate permissions. To create a full-text catalog the user must have CREATE FULLTEXT CATALOG permission on the database, or must be a...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Log In Register
Continue Reading →
Pro Members SQL Server Standard Members

Undocumented SQL Server 2017 Full-Text Search and XML procedures

by

Undocumented SQL Server 2017 Full-Text Search and XML procedures SQL Server 2017 supports the following useful undocumented SQL Server Full-Text Search and XML procedures: sp_fulltext_recycle_crawl_log sp_MShelpfulltextindex sp_MShelpfulltextscript sp_syscollector_validate_xml sp_xml_schema_rowset sp_xml_schema_rowset2 sp_fulltext_recycle_crawl_log The sp_fulltext_recycle_crawl_log system stored procedure is used to recycle crawl log for the given full-text catalog name. Syntax sp_fulltext_recycle_crawl_log [ @ftcat = ] ‘ftcat’ Arguments [ @ftcat = ]...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Log In Register
Continue Reading →
Pro Members SQL Server Standard Members

Tips for using full-text search in SQL Server 2017

by

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....

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Log In Register
Continue Reading →
Pro Members SQL Server Standard Members

Troubleshooting SQL Server 2016 full-text search

by

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...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Log In Register
Continue Reading →
SQL Server

Troubleshooting SQL Server 2014 full-text search

by

Troubleshooting SQL Server 2014 full-text search If you have problems with SQL Server 2014 full-text search, review this troubleshooting checklist to find potential solutions. 1. Install the latest SQL Server 2014 service pack. Because some SQL Server 2014 full-text search bugs were fixed in SQL Server service packs, you should install the latest SQL Server service pack. At the time […]

Continue Reading →
Pro Members SQL Server Standard Members

Tips for using full-text search in SQL Server 2014

by

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,...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Log In Register
Continue Reading →
Pro Members SQL Server Standard Members

Troubleshooting SQL Server 2012 full-text search

by

Troubleshooting SQL Server 2012 full-text search If you have problems with SQL Server 2012 full-text search, review this troubleshooting checklist to find potential solutions. 1. Install the latest SQL Server 2012 service pack. Because many SQL Server 2012 full-text search bugs were fixed in SQL Server service packs, you should install the latest SQL Server service pack. At the time...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Log In Register
Continue Reading →
Pro Members SQL Server Standard Members

Understanding SQL Server Full-text Indexing – (Part 2)

by

Understanding SQL Server Full-text Indexing – (Part 2) Author: Basit A. Farooq In this part, you will learn how to create full-text index using Transact-SQL, and how to manage and optimize full-text search catalogs and indexes. Creating a full-text index by using Transact- SQL To create a full-text index by using Transact-SQL: If the full-text catalog you want to store...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Log In Register
Continue Reading →
1 2