SQL Server 2000 is the latest and most powerful version of Microsoft's data warehousing and relational database management system.
Professional SQL Server 2000 Database Design provides an outline of the techniques that the designer can employ to make effective use of the full range of facilities that SQL Server 2000 offers. It attempts to move away from traditional texts on relational database design by considering design issues from a 'real world' point of view. To that end, it provides a full case study illustrating the scope of the designer's role - right from initial discussions regarding a client's needs, through development of a logical model, to full implementation of the system.
If you are standing in your favorite booksellers, flipping thorough this book because it is a WROX book, I
know you are probably thinking, “Hey, where is all of the code, and settings and such like?” Well, this is not
exactly that kind of book. (Not that there is anything wrong with that kind of book; I alone have a gaggle of
them around my desk.) What I wanted to put together in this case was a database design book that balances on
the thin line between the very implementation-oriented SQL Server books, where all they are concerned with
are DBCC settings, index options and all of the knobs and handles on SQL Server, and the truly academic
tomes that exist which go deep into the theory of databases, but provide little or no practical information.
This book covers the process of implementing a database from the point where someone mentions to you that
they want a database, all the way through to generating tables and implementing access to these tables. This
includes taking normalization of tables all the way to beyond fifth normal form.