SQL Server 2017 fixes the plan quality issues of previous releases via three new features: interleaved execution for multi-statement table-valued functions (TVFs), batch-mode execution adaptive joins, ...

Understand the effects of NULLs on inner and outer JOINs Your email has been sent SQL Server developers must understand two things: the difference between inner and outer JOINs and the effect of NULLs ...

RIGHT JOIN (or RIGHT OUTER JOIN): It’s the opposite of a LEFT JOIN. It keeps all rows from the right table and matches from the left. Less common than LEFT JOIN, but good to know it exists.