O'Reilly logo

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

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required