How you fool the sql server plan optimizer for better performance :)

Dear all,

Susantha Bathige who is one of my mentors, shared this link with me. I believe it is very useful.

Query Tuning Mastery: The Art and Science of Manhandling Paralellism
by Adam Machanic

https://www.youtube.com/watch?v=_IRWvlSQxS8&feature=youtu.be

Thanks Adam and Susantha.