title: Sql Server int vs nvarchar comparison on performance?
body: <p>For you database design/performance gurus out there.</p>
  
  <p>I'm designing a table, I have the choice of either use int or nvarchar (128) for a column, assume space is not a problem.  My question is which will give performance </p>
  
  <p>when I search with int column</p>
  
  <p><code>where ID = 12324</code></p>
  
  <p>or when I search with nvarchar column (the Key is the entire value, so I'm not using LIKE operator)</p>
  
  <p><code>where Key = 'my str'</code></p>
  
  <p>I'm sure for smaller datasets it doesn't matter, but let's assume this data will be in the millions of rows.</p>