title: Count(*) vs Count(Id) in sql server 2005
body: <p>I use SQL <code>COUNT</code> function to get the total number or rows from a table. Is there any difference between the two following statements?</p>
  
  <pre><code>SELECT COUNT(*) FROM Table
  </code></pre>
  
  <p>and  </p>
  
  <pre><code>SELECT COUNT(TableId) FROM Table
  </code></pre>
  
  <p>Also, is there any difference in terms of performance and execution time?</p>