title: Database having the exact same row of record..Why so?
body: <p>I have this issue over my DB..There is two row of record with exact same value, which doesn't make sense to me as I tried to insert the exact value using MS SQL Server, the client itself will prompt error --> <em>'Violation of UNIQUE KEY constraint 'IDX_XXX'. Cannot insert duplicate key in object 'table XXX'.
  The statement has been terminated.'</em></p>
  
  <p>So I wanted to know under what circumstances or database design will allow two exact record without having any error. </p>
  
  <p>The data is like below: </p>
  
  <pre>
  Column 1    ||  Column 2   ||  Column 3 
  ---------------------------------------
  Ferrari     ||  Rims       ||  Tyre 
  ---------------------------------------
  Ferrari     ||  Rims       ||  Tyre 
  </pre>