Intersect Operator

In this video Marco introduces the INTERSECT and EXCEPT operators available in SQL Server. This video focuses on how to use INTERSECT and explains basic rules to have in mind when combining 2 resultsets. If you're used to using UNION you'll appreciate the elegance of these operators.

From Portugal. 26 years old. Experience in a wide variety of business intelligence projects and industries (in particular communications, automotive, billing & payments, CRM). Currently working at the biggest Portuguese communications company as BI Architect, Performance/Tuning and Project Manadgement.

Leonard Peoples on 7/1/2010

Should prove useful

Michelle Poolet on 7/1/2010

1) If I understood the speaker correctly, he said that two NULL values (which is wrong, NULL is never a value, it is a condition) are considered equal. If SQL Server is configured to the ANSI standard, then two NULL conditions are never equal. 2) I felt that the need to have union-compatibility in the select statements was introduced much too late in the preso. 3) no mention was made of column alias, and where to create them. 4) no mention was made of how many selects can be part of an INTERSECT query.

Rosalind Philips on 7/1/2010

Why would you use intersect instead of doing an inner join on the tables? What type of overhead does intersect carry?

Jay on 7/1/2010

poor accent / hard to understand also video should have highlighted rows to visually avoid user having to scan list to confirm which rows are to be matched before. also didnt cover EXCEPT only covered INTERSECT

zishan qureshi on 7/2/2010

The picture quality of the videos is very bad.

B on 7/2/2010

same problem with his last video - hard to understand what he is saying because of his accent

Christian Bahnsen on 7/2/2010

Thanks, Marco. I didn't have any trouble understanding you but you may want to slow down a bit. You're getting better at zooming in. Keep up the good work.

Stephen Schneider on 7/2/2010

Marco, thanks for taking the time to put this video together. I had not used the intersect operator. I had no trouble understanding your voice or clearly seeing the video. Thanks again.

Philip Hickey on 7/2/2010

Nice job Marco and thanks for putting this together. I don't understand why some people are complaining about not being able to understand you. The pace and examples were excellent - keep up the great work!

John Barone on 7/2/2010

Thank you! I had never worked with this. The explanation was very clear. I can see how this may save me time in the future.

Marco Francisco on 7/3/2010

Thanks for the feedback. I appreciate that.I whould like to reply individually to email but cant see people's email. Thank you all.

Don Weigend on 7/6/2010

Good explanation!

Francis on 7/6/2010

Very clear and easy to understand. A simple 101 level walk-through of intersect. Nicely done.

7F718A6344 on 7/6/2010

nice,simple explanation

James Elliott on 7/7/2010

Very good job. Thank you for taking the time to put this video together. I had no problems understanding you presentation. Thank you.

Charlie Bruno on 7/7/2010

I learned something new, which is the point of these excellent and informative videos.

Ranch on 7/13/2010

A nice quick intro to the new operators

Dan on 8/9/2010

combine several topics into one vs. 200 seconds for this. Not bad though!

Sam Schafer on 2/4/2011

Very nicely done. The examples were very good and simply and clearly showed the intent of INTERSECT.

Sneha on 3/14/2011

Very Good Explanation of the operator instersect