December 2006
Beginner
912 pages
24h 44m
English
Content preview from Professional SQL Server™ 2005 Programming
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
21.1. Full-Text Search Architecture
The architecture surrounding FTS is something that confuses a lot of people. When you realize how the different pieces play together to make FTS happen, the confusion isn't that surprising.
The first thing to recognize is that the core of Full-Text Search isn't really part of SQL Server at all. Actually, it is a shared technology item that originally comes from Microsoft Index Server. The technology was originally implemented through a service known as MSSearch, and is now in its own service that is controlled by the SQL Server team (same original code base by my understanding though). This new service, called SQL Server FullText Search (it will have an instance name after it in the services applet if it is not part of the default SQL Server instance), is excellent at examining raw text data and aggregating word lists. By separating SQL Server's implementation of Full-Text Search from the O/S Indexing Service, Microsoft was able to increase the efficiency of how the full-text service communicates with the core database engine. The SQL Server FullTextService — or FTS — maintains an association between the individual words and phrases and the places that the FTS has encountered them.
Figure 21.1. Figure 21-1
In order to perform full-text queries against any SQL Server table, you must build a full-text index for that table. The construction and ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.