Summary

A good database design is the best place to start to ensure that your database application runs smoothly. This chapter outlined some of the fundamental aspects a database design that you should consider. If you have the luxury of designing the database system from the ground up, be sure to use what you learned in this chapter in the early stages of developing your database system. If you inherit a database with an inadequate design, the design principles described in this chapter still apply, but they may be a bit harder to implement.

The next chapter, “Monitoring SQL Server Performance,” delves into the tools and techniques you can use to evaluate the performance of your SQL Server instance. Monitoring is tightly linked to database ...

Get Microsoft SQL Server 2014 Unleashed now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.