Microsoft® SQL Server 2012 Unleashed

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 ...