Overview
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.
Explanation
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
Source Collcted from MSSQLTIPS.COM
No comments :
Post a Comment