title: Best type for ID column in SQL Server 2008
body: <p>I am a beginner of SQL Server 2008. there a colunm in table like <code>StudentID</code>.
  <code>StudentID</code> will be the pk of table, it only could be integer and it will be a huge number.</p>
  
  <p>My question is what type for column StudentID in SQL Server 2008 is best?</p>
  
  <p><code>bigint</code>?
  <code>numeric(18,0)</code>? or others?</p>
  
  <p>thanks a lot.</p>