This module discussed how and when to use full-text searching.
Full-text searching is a very powerful new tool in SQL Server 7 that allows you to search rapidly on very large text fields. Having completed this module, you should be able to:
- Describe what full-text searching is and when to use
- Describe considerations for full-text searching
- Practice implementing full-text searching
In the next module, you will learn how cursors can help you manipulate data in SQL Server record sets.
The history of Full-Text Search began in late 1998 when Microsoft reengineered one of its search engines
(Site Server Search, designed for websites) to provide search services for SQL Server 7. The engine was
called MSSearch, and it also provided search services to Exchange Content Indexing and SharePoint Portal
Server 2001. I liked Full-Text Search when it was first introduced back in SQL Server 7, and I am glad that it is
still here and Microsoft is continuing to invest in it.
Microsoft continued to improve iFTS’s performance and scalability with SQL Server 2000 and SQL Server
2005. Also, in case you did not follow the evolution of Full-Text Search back in SQL Server 2005, Microsoft
worked on bringing Full-Text Search closer to industry standards:
Before moving on to the next module, click the Quiz link below to check your knowledge of the material covered in this module with a short, multiple-choice quiz.
Full Text Searching - Quiz