BEGIN:VCALENDAR PRODID:-//Jive Software//Jive Events//EN METHOD:REQUEST VERSION:2.0 CALSCALE:GREGORIAN BEGIN:VEVENT DTSTAMP:20191213T231551Z ATTENDEE;ROLE=OPT-PARTICIPANT;PARTSTAT=NEEDS-ACTION;RSVP=TRUE: ORGANIZER;CN=;SENT-BY="MAILTO:null":MAILTO:event-community-solarwinds--co mmunity-community--events--webcasts--and--training@solarwinds-v9.hosted. jivesoftware.com DESCRIPTION;LANGUAGE=en-US:Go back to basics with this DPA webcast! When more than one table is involved in the query\, DBAs find themselves havi ng to answer questions about how indexes work with joins. Unfortunately\ , there’s a lot of misinformation out there. In this session\, we will d emystify some of the most popular myths related to SQL Server® joins\, i ndexes\, and performance. We’ll answer questions such as:\n\nDoes the or der of columns matter in joins?\nDoes the order of columns matter in ind exes?\nDoes the order of columns matter when used with joins and indexes ?\nHow do you optimize queries with multiple joins?\nDoes the order of t ables in the join matter for performance? \n\nJoin Pinal Dave on July 13 th at 12 PM EST. http://launch.solarwinds.com/DPAwebcast_EventLandingPa ge.html?CMP=THW-TAD-SWI-7.13-DPA-WEB-THW Register Today! \n\n*Speaker bi o:* Pinal Dave is a Technology Evangelist who’s worked in the IT industr y for more than 13 years. He received his Master of Science from the Uni versity of Southern California and a Bachelors of Engineering from Gujar at University. Additionally\, he holds many Microsoft® certifications. P inal writes frequently about various subjects\, especially SQL\, NoSQL\, and business intelligence on his blog\, http://blog.SQLAuthority.com h ttp://blog.SQLAuthority.com. He is known for his ability to translate co mplex subjects into simple contexts and applications\, and attracts over a million visitors a month to his site. His passion for helping the com munity drives him to share his training techniques and professional know ledge. When he is not in front of a computer\, he is usually traveling a nd exploring hidden natural treasures with his family. X-ALT-DESC;FMTTYPE=text/html;LANGUAGE=en-US:\n \n SQL Server Joins\, Indexes\, and Performance\n \n \n \n \n

Go back to basics with this DPA webcast! When more than one table is involved in the query\, DBAs find t hemselves having to answer questions about how indexes work with joins. Unfortunately\, there’s a lot of misinformation out there. In this sessi on\, we will demystify some of the most popular myths related to SQL Ser ver® joins\, indexes\, and performance. We’ll answer questions such as:< /p>\n

 \;

\n

D oes the order of columns matter in joins?

\n

Does the order of c olumns matter in indexes?

\n

Does the order of columns matter wh en used with joins and indexes?

\n

How do you optimize queries w ith multiple joins?

\n

Does the order of tables in the join matt er for performance?

\n

 \;

\n

Join Pinal Dave on July 13th at 12 PM EST. Register Today!

\n

 \;

\n

Speaker bio: Pinal Dave is a Technology Evangelist who’s worked in the IT industry for more than 13 y ears. He received his Master of Science from the University of Southern California and a Bachelors of Engineering from Gujarat University. Addit ionally\, he holds many Microsoft® certifications. Pinal writes frequent ly about various subjects\, especially SQL\, NoSQL\, and business intell igence on his blog\, http://blog.SQLAuthority.com< /a>. He is known for his ability to translate complex subjects int o simple contexts and applications\, and attracts over a million visitor s 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 hidde n natural treasures with his family.

\n \n \n \n SUMMARY;LANGUAGE=en-US:SQL Server Joins\, Indexes\, and Performance TZID:"America/Chicago" DTSTART:20170713T160000Z DTEND:20170713T170000Z UID:20170620T135735Z-jive-event@localhost CLASS:PUBLIC TRANSP:OPAQUE STATUS:CONFIRMED SEQUENCE:0 LOCATION;LANGUAGE=en-US:Online BEGIN:VALARM ACTION:DISPLAY DESCRIPTION:REMINDER TRIGGER;RELATED=START:-PT15M END:VALARM END:VEVENT END:VCALENDAR