title: Does SQL Server have an equivalent to MySql's sql_no_cache modifier?
body: <p>In MySql to test performance of an individual query, and take the query cache out of the picture, you can use the sql_no_cache modifier in your select statement:</p>
  
  <pre><code>select sql_no_cache * from Foo;
  </code></pre>
  
  <p>Is there a similar per-query option in Microsoft SQL Server? I have seen many posts about using:</p>
  
  <pre><code>CHECKPOINT
  DBCC DROPCLEANBUFFERS
  DBCC FREEPROCCACHE
  </code></pre>
  
  <p>but this seems like overkill and might give SQL Server a disadvantage when trying to compare performance to MySql for the same non-cached query.</p>