Guru's Guide to SQL Server Architecture and Internals, The

Knowledge Measure

1. What's the name of the DLL that SQL Server uses to interact with the Microsoft Search engine?

2. What undocumented DBCC command is used by the sp_fulltext… procedures to interact with the Microsoft Search service?

3. True or false: SQL Server's FTS facility can be installed on Windows 2000 Server but not on Windows 2000 Professional.

4. Name the two new predicate functions you can use on tables that have been full-text indexed.

5. What's the maximum number of full-text indexes a single table can have?

6. Is it possible to query both full-text indexed data and files that have been indexed by the Microsoft Indexing Service from the same T-SQL query?

7. Name the two new rowset functions you can use with tables that have been full-text indexed.

8. What T-SQL ...