SQL Joins Archives - Page 8 of 16 - SQL Authority with Pinal Dave

SQL Server – Understanding Table Hints with Examples

June 20, 2009

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

Today we have a very interesting subject to look at. I tried to look for help online but have not found any other documentation besides what we have from the Book Online. Let us try to understand what are the different kinds of hints available in SQL Server and how…

SQL SERVER – Introduction to JOINs – Basic of JOINs

April 13, 2009

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Best Practices, Database, SQL Joins, SQL Scripts, SQL User Group

The launch of Gandhinagar SQL Server User Group was a tremendous, astonishing success! It was overwhelming to see a large gathering of enthusiasts looking up to me (I was the Key Speaker) eager to enhance their knowledge and participate in some brainstorming discussions. Some members of User Group had requested…

SQL SERVER – Logical Query Processing Phases – Order of Statement Execution

April 6, 2009

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Database, Software Development, SQL Joins

Of late, I penned down an article – SQL SERVER – Interesting Observation of ON Clause on LEFT JOIN – How ON Clause Effects Resultset in LEFT JOIN – which received a very intriguing comment from one of my regular blog readers Craig. According to him this phenomenon happens due…

SQLAuthority News – Announcement – Gandhinagar SQL Server User Group – March 27, 2009

March 25, 2009

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News

DigiCorp, MVP, SQL Joins, SQL User Group, SQLAuthority Author Visit

It is my pleasure to announce new SQL Server User Group – Gandhinagar SQL Server User Group. We will be meeting every 2nd and 4th Friday of the month. Here is the detail for this months meeting. We will be having one gift for best participant in the meeting. I…

SQL SERVER – Interesting Observation of ON Clause on LEFT JOIN – How ON Clause affects Resultset in LEFT JOIN

March 15, 2009

Pinal Dave

SQL, SQL Performance, SQL Puzzle, SQL Server, SQL Tips and Tricks

SQL Joins, SQL Scripts

Today I received email from Yoel from Israel. He is one smart man always bringing up interesting questions. Let us see his latest email first. Hi Pinal, I am subscribed to your blog and enjoy reading it. I have a question which has been bothering me for some time now.…

SQL SERVER – INNER JOIN using LEFT JOIN statement – Performance Analysis

October 25, 2008

Pinal Dave

SQL, SQL Interview Questions and Answers, SQL Performance, SQL Server, SQL Tips and Tricks

SQL Joins, SQL Scripts

Just a day ago, while I was working with JOINs I find one interesting observation, which has prompted me to create following example. Before we continue further let me make very clear that INNER JOIN should be used where it can not be used and simulating INNER JOIN using any…

SQL SERVER – Get Common Records From Two Tables Without Using Join

October 17, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Joins, SQL Scripts

I really enjoy answering questions which I receive from either comments or Email. My passion is shared by SQL Server Expert Imran Mohammed. He frequently SQL community members by answering their questions frequently and promptly. Sachin Asked: Following is my scenario, Suppose Table 1 and Table 2 has same column…