I recently saw the worst example of how not to design a table and indexes in SQL Server.
So here it is:
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 [...]
Paul Randal wrote a very good answer on DB fragmentation here:
Some things any DBA should know.
I posted a comment on Kevin Kline’s blog regarding:
Microsoft Marketing Throws SQL Server Under the Bus
“A spokesperson for Microsoft said that the problem was not bandwidth but that its SQL Server database had reached excessive fragmentation levels caused by the tremendous surge of queries”. Read about it here: