SQL Database Concepts Question:

Can you explain Full-Text Query in SQL Server?

Basic SQL Server Interview Question
Basic SQL Server Interview Question

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 QuestionNext Question
Tell me what is SQL Profiler?Do you know what is Similarity and Difference between Truncate and Delete in SQL?