Full-Text Indexing

SQL Server supports mechanisms that allow you to store large amounts of unstructured text information. In older versions of SQL Server, you had the TEXT data type. With the more modern versions of SQL Server, you can use MAX values with the variable-length character data types VARCHAR and NVARCHAR. This means you can store up to 2GB worth of textual information within a single column. Since a standard index can hold only up to 900 bytes of information, there has to be another mechanism for searching within these large data types. That’s where full-text indexing comes into play.

Full-Text Indexing

Full-text search ...

Get Expert Performance Indexing in SQL Server, Second Edition now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.