I recently saw the worst example of how not to design a table and indexes in SQL Server.
So here it is:
Table1(UserID,ActivityID,ActivityType,AddDate)
Role : Log any activity that a user is invited for.
PrimaryKey: … Wait for it … tada : UserID,ActivityID,ActivityType,AddDate … Wait you say …. YES … all table columns are used [...]