Define Full-text indexing

Define Full-text indexing.

Full text search is achieved using Full text indexing in SQL Server. It enables full text queries against character based data. Searches can include words, phrases, multiples forms of a word/phrase etc. To allow this, full text indexes must be created for columns referenced in the queries. A full text index is made of word tokens derived from the indexed text.

Steps to implement full text indexing:
- Create a full text catalog.
- Create full text index
- Create a list of noise words to ignore
- Create a thesaurus for the language being used.

Define Full-text indexing.

A full text index has an index of type FULL TEXT. Full text indexing can only done for CHAR, VARCHAR, or TEXT columns. Currently searching using FULL TEXT index is only available in MYISAM tables. The full text index can be specified while creating the table or altering the table.

For e.g.

For searching:

Define Log shipping.

Log shipping is the process of shipping or automatically sending the transaction log which is already backed up at the primary server, to the secondary server. Once the log is copied to the secondary server instance, it is restored. The log can be shipped from one primary server instance to multiple secondary server instances. Log shipping increases data availability because if the primary database becomes unavailable, any of the secondary databases can be brought online manually.
What are the three types of Database files? Explain them
Database files are used for mapping the database over some operating system files. Data and log information are separate......
User defined data type concepts, syntax and an example
User defined data types are most commonly used when consistency among several tables storing the same type of data is desired........
Concepts behind placing indexes with filegroups
Indexes can be placed on different file groups to increase performance. By default, indexes are created on the same file group as the base table........
Post your comment