Feeds:
Posts
Comments

Archive for the ‘SQL Joins’ Category

SQL SERVER – Interesting Observation – Query Hint – FORCE ORDER

Posted in Best Practices, Pinal Dave, SQL, SQL Authority, SQL Index, SQL Joins, SQL Optimization, SQL Performance, SQL Puzzle, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, T SQL, Technology on October 6, 2009 | 9 Comments »

SQL Server never stops to amaze me. As regular readers of this blog already know that besides conducting corporate training, I work on large-scale projects on query optimizations and server tuning projects. In one of the recent projects, I have noticed that a Junior Database Developer used the query hint Force Order; when I asked [...]

Read Full Post »

SQL SERVER – Outer Join in Indexed View – Question to Readers

Posted in Pinal Dave, SQL, SQL Authority, SQL Index, SQL Joins, SQL Performance, SQL Query, SQL Server, SQL Tips and Tricks, SQL White Papers, SQLServer, T SQL, Technology, tagged on September 25, 2009 | 1 Comment »

Today I have question for you. Just a day ago I was reading whitepaper Improving Performance with SQL Server 2008 Indexed Views. Following is question and answer I read in the white paper.
Q. Why can’t I use OUTER JOIN in an indexed view?
A. Rows can logically disappear from an indexed view based on OUTER JOIN [...]

Read Full Post »

SQL Server – Multiple CTE in One SELECT Statement Query

Posted in Pinal Dave, SQL, SQL Authority, SQL Joins, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, T SQL, Technology, tagged on August 8, 2009 | 3 Comments »

I have previously written many articles on CTE. One question I get often is how to use multiple CTE in one query or multiple CTE in SELECT statement. Let us see quickly two examples for the same. I had done my best to take simplest examples in this subject.
Option 1 :
/* Method 1 */
;WITH CTE1 AS (SELECT 1 [...]

Read Full Post »

SQL Server – Understanding Table Hints with Examples

Posted in Pinal Dave, SQL, SQL Authority, SQL Joins, SQL Optimization, SQL Performance, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, T SQL, Technology, tagged on June 20, 2009 | 2 Comments »

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 they are helpful.
What is a Hint?
Hints [...]

Read Full Post »

SQL SERVER – Introduction to JOINs – Basic of JOINs

Posted in Best Practices, Database, Pinal Dave, SQL, SQL Authority, SQL Joins, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, SQL User Group, SQLServer, T SQL, Technology on April 13, 2009 | 49 Comments »

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 me to write a simple [...]

Read Full Post »

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

Posted in Database, Pinal Dave, Readers Contribution, Readers Question, SQL, SQL Authority, SQL Joins, SQL Query, SQL Server, SQL Tips and Tricks, SQLServer, Software Development, T SQL, Technology, tagged on April 6, 2009 | 22 Comments »

Download Logical Query Processing Poster
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 [...]

Read Full Post »

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

Posted in MVP, Pinal Dave, SQL, SQL Authority, SQL Joins, SQL Query, SQL Server, SQL Tips and Tricks, SQL User Group, SQLAuthority Author Visit, SQLAuthority News, T SQL, Technology, tagged on March 25, 2009 | 1 Comment »

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 request all the SQL enthusiast [...]

Read Full Post »

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

Posted in Pinal Dave, Readers Question, SQL, SQL Authority, SQL Joins, SQL Performance, SQL Puzzle, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, T SQL, Technology on March 15, 2009 | 16 Comments »

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.
When I want to filter records in a [...]

Read Full Post »

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

Posted in Pinal Dave, SQL, SQL Authority, SQL Interview Questions and Answers, SQL Joins, SQL Performance, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, T SQL, Technology on October 25, 2008 | 7 Comments »

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 other JOINs will degrade the [...]

Read Full Post »

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

Posted in Pinal Dave, Readers Contribution, Readers Question, SQL, SQL Authority, SQL Joins, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, T SQL, Technology on October 17, 2008 | 10 Comments »

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 e.g. Column1
Following is the query,
1. Select column1,column2 From [...]

Read Full Post »

Older Posts »