Question

Find one or more of the following articles. Provide the links to each article, the name of the article, and writer. (Each article has to discuss the three join methods used by SQL Server. When performing a join, the query optimizer chooses to use one of the three methods.)

Answer 1

Articles related to Join Methods used by SQL Server

1)
Link: https://www.itprotoday.com/sql-server/advanced-join-techniques
Name: Advanced JOIN Techniques
Writer: Itzik Ben-Gan, Kalen Delaney

2)
Link: https://docs.microsoft.com/en-us/sql/relational-databases/performance/joins?view=sql-server-2017
Name: Joins (SQL Server)
Writer: julieMSFT, Gene Milener, Craig Guyer, pmasl