I have
Professional SQL Server 2000 Database Design by Louis Davidson. Note that so people do not find his take on application/data architecture entirely agreeable, especially on the part of incorporating business logic/rules into the database schema and design.