SQL server design

SQL server design is de compleet package of tables, storedprocedures, schemas etc.

There are some guidelines, for example:

- Every table must have a primairy key

- Primairy key must be named TableNameId

- Primairy key must be of type Int wiht identity

- Primariy key constraint must be namen pkTableName

- All foreign constraints must be named fi: fkTable_Referencedtable

- All constraints must have an index

- All collumns null, if not null add comment why

- Create indexes for the top 20 queries. Include all necessarly columns

- Name indexes ixTable_purpose

- Never use Select * in Queries. Determine wich columns must be inncluded

- Dont use outer join when an inner join is enough





Saving your comment....

Naam is verplicht!
Email is verplicht!
Opmerking is verplicht!