Sunday, June 28, 2020

SQL Server Database Design guidelines

  • Balance Under-and-Over normalization 
  • Benefiting from Entity-Integrity Constraints
  • Benefiting from Domain and Referential Integrity Constraints 
  • Adopting Index-Design Best Practices 
  • Avoiding the use of the sp_Prefix fpr Stored Procedure Names 
  • Minimizing the use of Triggers

If there is any other better option,
Please share it here or mail to me arkaa4@gmail.com

Thank You,
Arka Gupta.

No comments:

Post a Comment