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 ...