SQL Database Concepts Question:
Can you explain Full-Text Query in SQL Server?
Answer:
SQL Server supports searches on character string columns using Full-Text Query. This query uses full-text catalogs and indexes to perform activities which are managed by the Microsoft search service. The full-text catalogs and indexes are not stored in a SQL Server database and they can't be backed up and restored by using the Transact-SQL BACKUP and RESTORE statements. The full-text catalogs must be resynchronized separately after a recovery or restore operation.
| Previous Question | Next Question |
| Tell me what is SQL Profiler? | Do you know what is Similarity and Difference between Truncate and Delete in SQL? |