Geek Sync Webcast : SQL Server Performance: The Myth of Table Joins

Presenter: Pinal Dave

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!

About Pinal:

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,

Register for Free Webcast

Note: By registering, you confirm that you agree to the processing of your personal data by Idera, Inc. as described in the Privacy Statement.
Idera, Inc. is part of the Idera group and may share your information with its parent company Idera, Inc., and its affiliates. For further details on how your data is used, stored, and shared, please review our Privacy Statement.