SQL SERVER – SQLServer Quiz 2011 – Do you know your execution plan – Two questions – One Answer
Posted
by pinaldave
on SQL Authority
See other posts from SQL Authority
or by pinaldave
Published on Tue, 15 Mar 2011 01:30:05 +0000
Indexed on
2011/03/15
8:13 UTC
Read the original article
Hit count: 535
Pinal Dave
|PostADay
|Readers Contribution
|Readers Question
|sql
|SQL Authority
|SQL Puzzle
|SQL Query
|SQL Scripts
|SQL Server
|SQL Tips and Tricks
|SQLServer
|T SQL
|Technology
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 (http://blog.SQLAuthority.com)
Filed under: Pinal Dave, PostADay, Readers Contribution, Readers Question, SQL, SQL Authority, SQL Puzzle, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, SQLServer, T SQL, Technology
© SQL Authority or respective owner
