SQL SERVER – 15 Best Practices for Better Database Performance:
SQL SERVER – 15 Best Practices for Better Database Performance: 1. Store relevant and necessary information in the database instead of application structure or array. 2. Use normalized tables in the database. Small multiple tables are usually better than one large table. 3. If you use any enumerated field to create look up for it in the database itself to maintain database integrity. 4. Keep primary key of lesser chars or integer. It is easier to process small width keys. 5. Store image paths or URLs in database instead of images. It has less overhead. 6. Use proper database types for the fields. If StartDate is database filed use date time as datatypes instead of VARCHAR (20). 7. Specify column names instead of using * in SELECT statement. 8. Use LIKE clause properly. If you are looking for exact match use “=” instead. 9. Write SQL keyword in capital letters for readability purpose. 10. Using JOIN is better for performance than using sub queries or nested queries. 11. Use stored p...
