• Sapen (9/4/2012)


    ...In my scenario what can you think will be a best column that I can have the primary key on.

    Thanks for your inputs in advance.

    By default primary key creates clustered index.

    But you create primary key with non-clustered index and create clustered index on some other column.