SQL Server 2012 Full-Text Search Optimization Tips Consider using the new custom NEAR option of the CONTAINS predicate or CONTAINSTABLE function. SQL Server 2012 introduces new custom NEAR option of the CONTAINS predicate or CONTAINSTABLE function. By using the custom NEAR option you can do the following: – optionally specify the maximum number of non-search terms that separate the first…