Category Archives: SQL Best Practices

SQL Best Practices

Importance of Best Practices in database programming

Best Practices in database programming For any programming language, just writing the code is not well enough. It should be written using the best practices. This article Best Practices in database programming¬† I will try to explain the disadvantages of … Continue reading

Posted in SQL Advanced, SQL Best Practices, SQL Server | Tagged | 32 Comments

Best practices for Database Programming

1. All the tables in the database have properly defined relationship using primary keys and foreign keys .2. Indexes should be created on the tables as it increases the performance of the SQL Queries. 3. Find the indexes which need … Continue reading

Posted in SQL Best Practices, SQL Server | Tagged | 31 Comments