You know the feeling, when you receive a stored procedure/query to make it better/faster
and after 20-30 minutes of searching/working you where able to run it under 1 sec ?
Today it happened to me too.
One stored procedure that had inside a function with lots a joins (15 aprx) …
some rewrites , some changes, some index and of course , the classic :
BR
S
Sql Server 