Good database design will be a luxury for a life time. Follow these basic guide lines to give a good database design.
- Bad logical database design results in bad physical database design, and generally results in poor database performance. So, if it is your responsibility to design a database from scratch, be sure you take the necessary time and effort to get the logical database design right. Once the logical design is right, then you also need to take the time to get the physical design right.
- Normalize your data to ensure best performance.
- Take advantage of SQL Server’s built-in referential integrity. You don’t need to write your own.
- Always specify the narrowest columns you can. In addition, always choose the smallest data type you need to hold the data you need to store in a column. The narrower the column, the less amount of data SQL Server has to store, and the faster SQL Server is able to read and write data.
- Try to avoid performing both OLTP and OLAP transactions within the same database.
Chosen from SQL Server DBA best practices By Brad M.mcGehee