Hi Kamil,

in fact you can control the SQL Query Optimizer very well.

Use

1. order joins with parenthesis
((T1 JOIN T2 ON ... ) LEFT JOIN ... )
2. use query hints : OPTION () clause ( example : OPTION(FORCE ORDER) )
3. use join  hints : () for control join type method
4. use table hints : WITH ( ) for control locks and index used on table

With a strong hints setting you can fixed the query plan.
However, to every SP or new version, the things can change.

Fabio