If a developer argues that these constraints are not necessary because the code manages the integrity, it can be argued that after implementing these constraints in the database there will...

To answer the question, they were stored in the database. Queries from the msdb table did show the packages present. In fact Enterprise Manager showed the packages. We just could...

This is really a separate topic from identities, but I feel that PKs should be clustered because they are so frequently used in joins. It seems that join performance is...

There are a number of factors to consider in this debate. My original training in relational design dictated 3rd normal form for databases. The easiest way that I could remember...