Why does referencing a variable in a join predicate force nested loops?9yr ⋅ martin-smith-3690 ⋅ se/dba
Why is using a table variable more than twice as fast as a #temp table in this specific case?13yr ⋅ martin-smith-3690 ⋅ se/dba
