O'Reilly logo

A Developer’s Guide to Data Modeling for SQL Server: Covering SQL Server 2005 and 2008 by Joshua Jones, Eric Johnson

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

CHAPTER 8COMMON DATA MODELING PROBLEMS

Perfecting a data model is no easy task. To do it correctly, you must balance the physical limitations of SQL Server 2008 and simultaneously meet the requirements of your customer’s business. Along the way, there are several pitfalls you may encounter. Many of the problems you will face are quite common, and you can avoid them by understanding them. In this chapter, we discuss some of the more common modeling problems and explain how to identify them, how to fix them if they occur, and how to avoid them altogether.

Entity Problems

Data models are built around entities, so that is where we start when looking for problems. Some entity problems are obvious, and others are a little harder to pick up on and fix. ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required