SQL Joins « SQL Server Journey with SQL Authority

Archive for the ‘SQL Joins’ Category

SQL SERVER – Quick Note about JOIN – Common Questions and Simple Answers

Posted in Pinal Dave, PostADay, SQL, SQL Authority, SQL Joins, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, T SQL, Technology on October 4, 2011 | 6 Comments »

This blog post is written in response to the T-SQL Tuesday post of JOIN. This is a very interesting subject. Years ago, I wrote my article about SQL SERVER – Introduction to JOINs – Basic of JOINs, ‑ till date, it is my most favorite article on the blog. Today we are going to talk [...]

Read Full Post »

SQL SERVER- Differences Between Left Join and Left Outer Join

Posted in Pinal Dave, PostADay, SQL, SQL Authority, SQL Joins, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, T SQL, Technology on January 22, 2011 | 11 Comments »

There are a few questions that I had decided not to discuss on this blog because I think they are very simple and many of us know it. Many times, I even receive not-so positive notes from several readers when I am writing something simple. However, assuming that we know all and beginners should know [...]

Read Full Post »

SQLAuthority News – Statistics and Best Practices – Virtual Tech Days – Nov 22, 2010

Posted in MVP, Pinal Dave, SQL, SQL Authority, SQL Joins, SQL Optimization, SQL Performance, SQL Query, SQL Server, SQL Tips and Tricks, SQLAuthority News, T SQL, Technology, tagged SQL Statistics, Statistics on November 22, 2010 | 4 Comments »

I am honored that I have been invited to speak at Virtual TechDays on Nov 22, 2010 by Microsoft. I will be speaking on my favorite subject of Statistics and Best Practices. This exclusive online event will have 80 deep technical sessions across 3 days – and, attendance is completely FREE. There are dedicated tracks [...]

Read Full Post »

SQL SERVER – SELF JOIN Not Allowed in Indexed View – Limitation of the View 9

Posted in Pinal Dave, SQL, SQL Authority, SQL Index, SQL Joins, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, SQL View, T SQL, Technology on September 26, 2010 | 3 Comments »

Update: Please read the summary post of all the 11 Limitations of the view SQL SERVER – The Limitations of the Views – Eleven and more… Previously, I wrote an article about SQL SERVER – The Self Join – Inner Join and Outer Join, and that blog post seems very popular because of its interesting [...]

Read Full Post »

SQL SERVER – Outer Join Not Allowed in Indexed Views – Limitation of the View 8

Posted in Pinal Dave, SQL, SQL Authority, SQL Joins, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, SQL View, T SQL, Technology on September 24, 2010 | 2 Comments »

Update: Please read the summary post of all the 11 Limitations of the view SQL SERVER – The Limitations of the Views – Eleven and more… This blog post was previously published over here. I am republishing it in the series Limitation of the Views with a few modifications. While reading the white paper Improving [...]

Read Full Post »

Older Posts »