SQL Best Practices Archives - Technology with Vivek Johari

Importance of Best Practices in database programming

February 1, 2015January 27, 2019 vivekjohari32 Comments

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 writing code without using Best Practices and later on how best practices can be implemented […]

Best practices for Database Programming

August 11, 2014January 27, 2019 vivekjohari31 Comments

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 to be reorganized or rebuild. 4. Use “set not count on/off” as it will increases […]