Lesson Learned #191: Performance comparison using Inner vs Left Join in Linked Server/Elastic Query

Today, I worked on a very interesting performance service request when our customer is using Linked Server and/or Elastic Query joining with other local and remote queries. Following, I would like to...