SQL Server Database Design Best Practices Tutorial
By: Armando Prato
Many databases are initially developed by professionals not deeply experienced in database development. In a lot of instances, an application engineer is drafted with the task of designing a table or database due to the lack of an available database resource. Unfortunately, sometimes working outside one's area of expertise can sometimes lead to making technical decisions that are later discovered to be less than optimal.
The goal of this tutorial is to help non-database and database professionals alike recognize sound development practices and to recognize practices and techniques that could lead to future technical headaches.
With this goal in mind, the following topics will be examined:
- Logical Design
- Defining Data Types and Sizes
- Defining a Primary Key
- Defining a Clustered Index
- Defining Constraints
- Choosing Non-Clustered Indexes
- Prepared Queries and Stored Procedures
- Querying in Sets
- Preventing Index Nullification
- Temporary Tables and Table Variables
- Working With Triggers