title: Count(*) vs Count(1) - SQL Server
body: <p>Just wondering if any of you people use <code>Count(1)</code> over <code>Count(*)</code> and if there is a noticeable difference in performance or if this is just a legacy habit that has been brought forward from days gone past?</p>
  
  <p>The specific database is <code>SQL Server 2005</code>.</p>