O'Reilly logo

Microsoft SQL Server 2012 Internals by Bob Beauchemin Kalen Delaney Conor Cunningham, Jonathan Kehayias, Benjamin Nevarez, and Paul S. Randal

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

Full-text indexes

Full-text indexes have been included in SQL Server since SQL Server 7.0, although they have changed drastically in implementation over the last few releases. In SQL Server 2008, the data structures for full-text search were brought into the database; before then, the full-text search indexes were run in instances of Microsoft Search Server. In SQL Server 2008, the index itself resides in the database as a set of internal tables, and most of the indexing and processing is done inside the SQL Server process. This section concentrates on the SQL Server 2012 implementation, which is similar to the SQL Server 2008 implementation with a number of performance enhancements and some additional features.

As opposed to XML and spatial data, ...

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