SQL Server Joins, Indexes, and Performance

Event has ended



When more than one table is involved in the query, DBAs find themselves having to answer questions about how indexes work with joins. Unfortunately, there’s a lot of misinformation out there. In this session, we will demystify some of the most popular myths related to SQL Server® joins, indexes, and performance. We’ll answer questions such as:

  • Does the order of columns matter in joins?
  • Does the order of columns matter in indexes?
  • Does the order of columns matter when used with joins and indexes?
  • How do you optimize queries with multiple joins?
  • Does the order of tables in the join matter for performance?


Join Pinal Dave for this live webcast on July 13th, Register today! >>


Pinal Dave is a Technology Evangelist who’s worked in the IT industry for more than 13 years. He received his Master of Science from the University of Southern California and a Bachelors of Engineering from Gujarat University. Additionally, he holds many Microsoft® certifications. Pinal writes frequently about various subjects, especially SQL, NoSQL, and business intelligence on his blog, http://blog.SQLAuthority.com. He is known for his ability to translate complex subjects into simple contexts and applications, and attracts over a million visitors a month to his site. His passion for helping the community drives him to share his training techniques and professional knowledge. When he is not in front of a computer, he is usually traveling and exploring hidden natural treasures with his family.

When and Where

  • Start Time:

    Jul 13, 2017 11:00 AM CST (America/Chicago)
  • End Time:

    Jul 13, 2017 12:00 PM CST (America/Chicago)
  • Location:


Event Info

  • Event Type:

  • Event Visibility & Attendance Policy:


Contact Info


SolarWinds uses cookies on its websites to make your online experience easier and better. By using our website, you consent to our use of cookies. For more information on cookies, see our cookie policy.