Efficient use of JOIN operations in SQL Server can drastically reduce query times. The server offers various JOIN types, such as INNER JOIN, LEFT JOIN, and RIGHT JOIN, each serving specific purposes.

Now thanks to SQL Server 2005/2008, query execution and analyzing is too very much easy. We can do this using reporting services but lets take a bit more convenient way to find out how a query is ...