SQL Optimization

Here’s collection of links and thoughts about how to perform optimization of a SQL Query and performance tuning of SQL Server:

  • Links:
  • 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.