title: is date is good candidate for clustred index key
body: <p>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</p>