Posted on

Quizzes: Logical and Physical Joins in SQL Server

One highlight of my week is writing a quiz for my weekly quizletter. It’s also one of the most difficult things I do, because nothing teaches you about how tricky wording is like writing a quiz! In recent weeks I’ve done a couple of quizzes on joins.

Did you miss either of these quizzes? If so, it’s the perfect Friday to have a little quiz fun and learn about joins!

Quiz 1: Logical joins

Do you know the nitty gritty on inner joins, outer joins, and cross applies in TSQL? Or are you just interested to learn? Either way, take the eight-question quiz on logical joins.

Quiz 2: Physical joins

How well can you identify the physical join operators seen in SQL Server’s graphical execution plans? Dive into this six-question quiz.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.