title: SQL 2008 full text search with ORDER BY and TOP clause and no answer from the server
body: <p>I have the following SQL query:</p>
  
  <pre><code>SELECT TOP 200 * FROM article WITH (nolock) 
  WHERE CONTAINS(*,'"ram*" and "1*"')
  ORDER BY article_number
  </code></pre>
  
  <p>I am getting no results returned within 10 minute. If I stop the query after a few minutes then it returns a few records.</p>
  
  <p>In <code>article</code> table there are 10,000 records. The full text catalog is on <code>article</code> 4-5 fields, so it contains only 1 table.</p>
  
  <p>If I don't write the <code>ORDER BY</code> or the <code>TOP 200</code> clause then it returns immediately with the correct answer.</p>
  
  <p>Article table has <code>INDEX (Unique, clustered)</code> on <code>Article_number</code>. </p>
  
  <p>I think it is an MS-SQL 2008 bug.</p>
  
  <p>The problem also exists on SQL 2008 SP1.</p>
  
  <p>I really don't understand the problem, please help.</p>