January 17, 2017 SSWUG.org is hosting a great event for those wishing to improve their SQL skills. This free webcast is titled “All About Joins”. Read more at https://sswug.org/events/.
SQL Server supports the different ANSI join methods that are the core capability of any SQL Engine. However, in order to optimize performance, there are different implementations for joining data between two tables. If you are not well versed on the difference between a loop join, a merge join, or a hash join, then this event is designed for you.
Database performance is based on two different query requirements. Filtering is used for a single table, implemented in the WHERE clause, where you restrict the returned rows based on some criteria of the table. Joins are the second feature that impacts performance. The difference in this case is that you are filtering based on the existence of records in two tables.
When you have more complex queries that retrieve data from three or more tables, then the performance of the database is impacted more by your understanding of what is going on when you use the JOIN syntax in a query. The All About Joins event will help you understand more fully what is going on when you use Filtering and Joining in your queries. Learning to read and understand information provided in a query plan is a key skill for any database professional, even if you are not a DBA.
This should be a great event. I hope you will be sure to attend. It will be well worth your time.
Cheers,
Ben