title: Store array of numbers in database field
body: <p>Context: SQL Server 2008, C#  </p>
  
  <p>I have an array of integers (0-10 elements). Data doesn't change often, but is retrieved often.  </p>
  
  <p>I could create a separate table to store the numbers, but for some reason it feels like that wouldn't be optimal.  </p>
  
  <p><strong>Question #1:</strong> Should I store my array in a separate table? Please give reasons for one way or the other.  </p>
  
  <p><strong>Question #2:</strong> (regardless of what the answer to Q#1 is), what's the "best" way to store int[] in database field? XML? JSON? CSV?</p>
  
  <p><strong>EDIT:</strong>
  Some background: numbers being stored are just some coefficients that don't participate in any relationship, and are always used as an array (i.e. never a value is being retrieved or used in isolation).</p>