Table of Contents

 

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

Summary

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?