Summary

Completed

Database design is a critical component of overall performance. The SQL Server platform offers a number of options for building indexes and compressing data for better performance. Using the proper data types and storage mechanisms can also help the performance of your applications.

Now that you've reviewed this module, you should be able to:

  • Understand normal form and how it affects database design
  • Choose appropriate datatypes for your database
  • Understand types of indexes