Pro SQL Server 2008 Relational Database Design and Implementation

Louis Davidson's book on database design is a solid, five-star book on Amazon that is reviewed and endorsed by leading lights such as Adam Mechanic and James Luetkehoelter. The book is technically and theoretically sound, and is grounded in best-practices. The previous two editions have sold in excess of 5000 units. There is no better book on database design catering to the SQL Server professional.