title: Small Colum and large table - Should i use FTS or Like
body: <p>At the moment i am using Full text (2008 R2) on small columns like 'Client Name', 'PO Number' and etc ? but i was wondering if it is really worth using FTS on small columns and could use 'Like' for searching.</p>
  
  <p>Table has over 11k rows which is not alot but this table is growing.</p>
  
  <p>If it is better to use 'Like' than do i have to remove columns from the catalog?</p>
  
  <p>What is meant by unstructured text data here?</p>
  
  <p>"In contrast to full-text search, the LIKE Transact-SQL predicate works on character patterns only. Also, you cannot use the LIKE predicate to query formatted binary data. Furthermore, a LIKE query against a large amount of unstructured text data is much slower than an equivalent full-text query against the same data. A LIKE query against millions of rows of text data can take minutes to return; whereas a full-text query can take only seconds or less against the same data, depending on the number of rows that are returned. "</p>