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: 1496 | Points: 40

Select from following answers:

Show Correct Answer

Asked In: Many Interviews | Alert Moderator

Bookmark It

< Previous : The transaction isolation level controls the locki ...

Next > : As part of a new HR project you're creating se ...

More Interview Questions by Bandi

Latest Interview Questions