title: How can I clear the SQL Server query cache?
body: <p>I've got a simple query running against SQL Server 2005</p>
  
  <pre><code>SELECT * 
  FROM Table 
  WHERE Col = 'someval'
  </code></pre>
  
  <p>The first time I execute the query can take <code>&gt; 15 secs</code>. Subsequent executes are back in <code>&lt; 1 sec</code>.</p>
  
  <p>How can I get SQL Server 2005 not to use any cached results? I've tried running</p>
  
  <pre><code>DBCC DROPCLEANBUFFERS
  DBCC FREEPROCCACHE
  </code></pre>
  
  <p>But this seems to have no effect on the query speed (still <code>&lt; 1 sec</code>).</p>