Top 10 Best Practices of SQL Server Database
- Always make sure that you are clear about your IO for your SQL server and your IO of your Application.
- Use error handlers such as Transactions, Try Catch, and Triggers so that the system will not go into breakout mode.
- Always keep your table simple and in Normalized Form instead of making one huge table, this offers good performance and more flexibility.
- Make sure that Validations and Conversions are done properly before to and fro flow of data between application and the database.
- Use of Temp Table should be done wherever possible so as to avoid heavy queries on large databases.
- Use of Stored procedures and Functions is one of the best practices rather than writing the query again and again.
- Always use Indexing method wherever possible.
- Test your query before actual implementation.
- Also try to use Dynamic Query sometime as it is more beneficial than non-dynamic query.
- Try to avoid storage of redundant data in your database.