The Perfect Mix of Technology & Knowledge
For any programming language, just writing the code is not well enough. It should be written using the best practices for getting optimise performance . In this article, I will explain the disadvantages of writing code without using Best Practices in SQL Coding. Later, I will describe how best practices can be implemented in our … Read more
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 … Read more
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 … Read more
