Performance Tuning is a complicated subject and when there are multiple tables involved, tuning can get even more complex. DBAs and SQL developers often argue about the significance of joins and how it plays its role in performance tuning.
Join IDERA and Pinal Dave as he demystifies some of the most popular myths related to SQL Server joins, indexes, and performance. Pinal will discuss the difference between logical and physical joins, column order within joins, and how to optimize queries with multiple joins. He will also explain when the order of tables and columns matter when it comes to server performance. This will be an interactive Geek Sync you will not want to miss!
Pinal Dave is a technology enthusiast and independent consultant with over thirteen years of experience in the information technology sector. He has successfully authored 11 SQL Server database books, 18 Pluralsight courses and written over 3200 articles on database technology via his blog http://blog.sqlauthority.com. Rounding out his professional career, Pinal has held key positions as Sr. Consultant for SolidQ and as a Technology Evangelist for Pluralist and Microsoft. Pinal holds a Master of Science from the University of Southern California, and numerous professional certifications, including MCTS, MCDBA and MCAD (.NET).
Topics: Database Performance, SQL Query Performance Products: DB Optimizer