is date is good candidate for clustred index key

Question

i open one transaction and insert a row into table and close the ssms and reopen and check table but uncommitted transaction were in the resultset why this happen please tell me

Answer 1

date can be a good primary key for clustered index, but in general scenario, we don't link many tables (foreign key) using date.

i think it is depend on your er-diagram.