Abstract
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.
Keywords
Execution Plan Shipping Company Query Plan Index Creation Incremental Population
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.
Copyright information
© Jason Strate and Grant Fritchey 2015