Note: Lifetime Access

Abstract:Each time you look at the execution plan, you can come across the join operators. Almost always. And you have observed three different types of joins – Nested Loop, MERGE Join & Hash Join. Yeah, you know they are performing a join between two tables, but what exactly is the difference between them? Join this webinar, where Amit Bansal (Microsoft Certified Master of SQL Server) will give you a practical explanation of what each one means and why exactly is the optimizer choosing a specific join type. Yeah, become a better SQL Server professional.