Intelligent database design is perhaps the most critical element of an optimal SQL Server solution with respect to performance. In fact, poor design is usually the culprit for poorly performing SQL Server solutions. This section discusses critical design factors that must be considered to produce an efficient, logical database design. It is assumed you are familiar with relational database design concepts such as entity-relationship modeling and normalization.