To assist our SQL Server clients, we have created a sample Full-Text Index script against the ciqTranscriptComponent table and ComponentText column which assists in improving query performance (speed of queries improved ~9x based on our testing). The ComponentText column within the ciqTranscriptComponent table is a SQL nvarchar(max) datatype that contains large strings of text. Using the LIKE predicate in the WHERE clause against this column results in slow query speeds. With Full-Text Indexing, users are able to use the CONTAINS predicate which utilizes the Full-Text Indexed columns thus improving query speed.