A Developer’s Guide to Data Modeling for SQL Server: Covering SQL Server 2005 and 2008

PREFACE

As database professionals, we are frequently asked to come into existing environments and “fix” existing databases. This is usually because of performance problems that application developers and users have uncovered over the lifetime of a given application. Inevitably, the expectation is that we can work some magic database voodoo and the performance problems will go away. Unfortunately, as most of you already know, the problem often lies within the design of the database. We often spend hours in meetings trying to justify the cost of redesigning an entire database in order to support the actual requirements of the application as well as the performance needs of the business. We often find ourselves tempering good design with real-world ...