My friend Jacob Sebastian has SQL Server Quiz 2011 launched. This time when he asked me to come up with quiz question – I wanted to come up with something which is new and make participant to think about it.
After carefully thinking I come with question which I really like to solve myself.
Here is the details:
1) Using Single table only Once in Single SELECT statement generate execution plan which have JOIN operator. Explain the reason for the same.
2) Using Single table only Once in Single SELECT statement generate execution plan which have parallelism operator. Explain the reason for the same.
Bonus: Create a single query which satisfy both of the above statement.
To answer this question and win exciting gifts please visit the SQL Server Quiz website.
Reference: Pinal Dave (https://blog.sqlauthority.com)