Here’s collection of links and thoughts about how to perform optimization of a SQL Query and performance tuning of SQL Server:
- Links:
- MSSQLTips.com has got the ultimate guide – https://www.mssqltips.com/sql-server-tip-category/9/performance-tuning/
- Thoughts:
- Avoid using cross join: includes FROM clause where tables names are put with comma (,)
- Avoid performing string operations in WHERE clause or in inner SELECT: String operations like – LTRIM, RTRIM, SUBSTRING, UPPER, etc.