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.