Performance View on INNER JOIN and OUTER JOIN

Hope you guys are getting ready for Diwali Festival :-). Before you guys start with the festival event I thought of writing an article on performance.¬† Couple of days ago one of the developer came to me and said he was using¬† an INNER join in his query and he is getting delay in results,… Continue reading Performance View on INNER JOIN and OUTER JOIN

SQL Server Joins

SQL Server joins are required to retrieve data from one or more tables to get a single result set. Joins are needed when Normalization enforced in design. When you normalize the data you be reducing redundancy in data by placing data in different tables and also you will be creating relationship between the tables. With… Continue reading SQL Server Joins