T-SQL: Performance Issues with View; runs slow

I would drop subquery in the select list and min/max and GROUP BY in the query and rather re-write it with ROW_NUMBER(), cte and appropriate partition. You may also remove some of the extra joins and start from the basic adding extra tables one at a time.

---

For every expert, there is an equal and opposite expert. - Becker's Law





My blog



My TechNet articles