Term
| What must be done before you can create a full-text index? |
|
Definition
| You must first create a full text catalog that is mapped to a filegroup to contain one or more full text indexes. |
|
|
Term
| What column types can full text indexes be built upon? |
|
Definition
- char
- varchar
- nchar
- nvarchar
- text
- ntext
- image
- xml
- varbinary
- varbinary(max)
* |
|
|
Term
| What do you need to specify to create a full text index on documents stored within a FILESTREAM? |
|
Definition
| the documents are stored in a VARBINARY(MAX) column with the FILESTREAM property enabled; to create the full text index, a type column (that designates what type of doc is stored in the VARBINARY(MAX) column) must be specified in order for the word breaker to load the appropriate filter to parse it. |
|
|
Term
|
Definition
| word breakers are assemblies that locate breaks between words to build a list of words to be indexed. |
|
|
Term
|
Definition
| a service that conjugates verbs so that your queries can locate information even across multiple verb tenses. |
|
|
Term
| Where are the contents of a full text catalog maintained? |
|
Definition
| In a filegroup in the database. Prior to SQL Server 2008, the entire contents of the catalog were maintained in a directory structure on the operating system. |
|
|
Term
| Which catalog option allows you to configure whether the full text engine considers accent marks when building or querying a full text index? |
|
Definition
|
|
Term
| Why is the population of a full-text index not an immediate process like it is with a relational index? |
|
Definition
| because the data has to be submitted to the indexing engine, which then applies word breakers, stemmers, language files, and stop lists before merging the changes into the index. |
|
|
Term
| Which full text index option determines how SQL Server maintains the index when the underlying data changes, and what do the settings mean? |
|
Definition
CHANGE_TRACKING.
Manual/Auto: SQL Server maintains a list of changes to the indexed data.
Manual: you are responsible for periodically propagating the changes into the full text index.
Auto: SQL Server automatically updates the full text index as the data is modified. |
|
|
Term
|
Definition
| The list of common words that you would not normally search text upon. Includes such words as the, and, and a in the English language. |
|
|
