title: LIKE vs CONTAINS on SQL Server
body: <p>Which one of the following queries is faster (LIKE vs CONTAINS)?</p>
  
  <pre><code>SELECT * FROM table WHERE Column LIKE '%test%';
  </code></pre>
  
  <p>or</p>
  
  <pre><code>SELECT * FROM table WHERE Contains(Column, "test");
  </code></pre>