Just out of curiosity..
When designing a new table what should be the criteria for deciding the following:
1) primary key (to use clustered or non-clustered index on primary key?)
2) clustered index col
3) non - clustered index cols
is there any general rule of thumb here?
Thanks