Skip navigation

SQL Server Joins, Indexes, and Performance

Event has ended

Loading...

Description

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:

    Online

Event Info

  • Event Type:

    Webinar
  • Event Visibility & Attendance Policy:

    Open

Contact Info

Comments