You're designing a new SQL Server 2012 table that will hold millions of records. The table will be used by a finance application to show historical transactions. The table only has 10 columns but it's vital that the table performs well. How many primary keys should you create for the table for best performance?

 Posted by Bandi on 7/30/2014 | Category: Sql Server Interview questions | Views: 1408 | Points: 40
Select from following answers:
  1. 2
  2. 10
  3. 3
  4. 1
  5. All Above

Show Correct Answer

Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response