A Developer's Guide to Data Modeling for SQL Server
Covering SQL Server 2005 and 2008
Effective data modeling is essential to ensuring that your databases will perform well, scale well, and evolve to meet changing requirements. However, if you're modeling databases to run on Microsoft SQL Server 2008 or 2005, theoretical or platform-agnostic data modeling knowledge isn't enough: models that don't reflect SQL Server's unique real-world strengths and weaknesses often lead to disastrous performance.
Share A Developer's Guide to Data Modeling for SQL Server