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

Chapter 16. Full-Text Search

I have never imputed to Nature a purpose or a goal, or anything that could be understood as anthropomorphic. What I see in Nature is a magnificent structure that we can comprehend only very imperfectly, and that must fill a thinking person with a feeling of humility. This is a genuinely religious feeling that has nothing to do with mysticism.

—Albert Einstein^[1]

^[1] Einstein, Albert, as quoted by Helen Dukas in Albert Einstein, the Human Side. Princeton, NJ: Princeton University Press, 1981, p. 39.

In this chapter, we'll talk about SQL Server's Full-Text Search (FTS) facility and the engine behind it, the Microsoft Search service. We'll talk about how FTS works and explore how you can use full-text queries to retrieve ...