Copyright
Brief Table of Contents
Table of Contents
List of Figures
List of Tables
List of Listings
MVP contributors and their chapters
Preface
Acknowledgments
About War Child
About this Book
About SQL Server MVPs
1. Database design and architecture
Chapter 1. Louis and Paul’s 10 key relational database design ideas
1. Denormalization is for wimps
2. Keys are key
3. Generalize, man!
4. Class <> table
5. Data drives design
6. Sets good, cursors bad
7. Properly type data
8. Extensibility through encapsulation
9. Spaghetti is food, not code
10. NOLOCK = no consistency
Summary
About the authors
Chapter 2. SQL Server tools for maintaining data integrity
Protection tools
Data types
NULL specification
Uniqueness constraints
Filtered unique indexes
Foreign key constraints
Check constraints
Triggers
When and why to use what tool
About the author
Chapter 3. Finding functional dependencies
Interview method
Modeling the sales order
First step: finding single-attribute dependencies
Second step: finding two-attribute dependencies
Further steps: three-and-more-attribute dependencies
What if I have some independent attributes left?