Great timing, Ayende! With Halloween right around the corner, let's make October scary schema month!
Here is one that recently made my hair stand on end:
This healthcare schema defines a composite primary key using 5 varchar fields and 2 datetime fields. If you think the index is scary, you should see the joins…
Do you have a scary schema to share?