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)
Event Visibility & Attendance Policy:Open
- kdoody (Owner)