Fail « Positively SQL

How (not) to design a SQL Server table

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 [...]

Eduard gives us the following problem:

The result is that every 4 years for a day you realized the money spent on a Zune are wasted

http://www.engadget.com/2008/12/31/30gb-zunes-mysteriously-begin-to-fail-at-12am-december-31st/

Now for the Microsoft solution (Please refrain from ROTFL ! ):

Follow these steps:

Disconnect your Zune from USB and AC power sources. Because the player [...]