Top 20 tips to optimize your T-SQL code (Part-2) Author: Basit A. Farooq In this second of the two part article series, I will share the last 10 tips that you can follow to optimize T-SQL code. Tip#11: Avoid overindexing tables Indexes are the solution to many performance problems, but too many indexes on tables affect the performance of INSERT,...
Tag: tips to optimize sql code; index guidelines
Top 20 tips to optimize your T-SQL code (Part-2)
Top 20 tips to optimize your T-SQL code (Part-2) Author: Basit A. Farooq In this second of the two part article series, I will share the last 10 tips that you can follow to optimize T-SQL code. Tip#11: Avoid overindexing tables Indexes are the solution to many performance problems, but too many indexes on tables affect the performance of INSERT, […]