Expert Performance Indexing in SQL Server 2019: Toward Faster Results and Lower Maintenance

© Jason Strate 2019

J. StrateExpert Performance Indexing in SQL Server 2019https://doi.org/10.1007/978-1-4842-5464-6_7

7. Full-Text Indexing

Jason Strate¹ 

(1)

Hugo, MN, USA

 

SQL Server supports mechanisms that allow you to store large amounts of unstructured text information. Since SQL Server 2008, one of those mechanisms has been the MAX lengthused with the variable-length character data types VARCHAR and NVARCHAR. This means you can store up to 2 GB worth of character information within a single column. While SQL Server can store this information, the 1,700-byte limit for nonclustered indexes and 900-byte limit on clustered indexes make indexing through traditional means a challenge. Fortunately, SQL Server offers another indexing mechanism for ...