Batch-mode execution adaptive joins: SQL Server typically chooses between three types of physical join operators: nested loop joins, merge joins, and hash joins. Each type of join has strengths and ...