A join is a lookup
A join is a nested loop over rows
A join is a nested loop over columns
A join is compatible alternate realities
A join is flatMap
A join is the solution to the N+1 problem
A join is paths through a graph
A join is a minimal model
A join is typechecking
A join is an operation in the Set monad
A join is the biggest acceptable relation
A join is a…join
A join is a ring product
One of the new Extended Event available in SQL Server 2022 is the query_antipattern.
This extended event allows to identify anti-patterns on the SQL queries
sent to the server. An anti-pattern in this case is some code that the
SQL Server optimizer can’t do a great job optimizing the code (but
cannot correct the issue automatically).