Joins in single-table querieshttp://sqlblog.com/blogs/rob_farley/archive/2012/12/11/joins-in-single-table-queries.aspxTables are only metadata. They don’t store data. I’ve written something about this before, but I want to take a viewpoint of this idea around the topic of joins, especially since it’s the topic for T-SQL Tuesday this month. Hosted this time by SebastianenCommunityServer 2.1 SP2 (Build: 61129.1)re: Joins in single-table querieshttp://sqlblog.com/blogs/rob_farley/archive/2012/12/11/joins-in-single-table-queries.aspx#46602Tue, 11 Dec 2012 00:24:57 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:46602Ben Laan<p>Good write up Rob. I was just explaining this exact concept to someone last week - not as well though, so I've just sent him a link to it!</p> <p>The examples in particular make it quite straight forward.</p> <p>Thanks</p>re: Joins in single-table querieshttp://sqlblog.com/blogs/rob_farley/archive/2012/12/11/joins-in-single-table-queries.aspx#46609Tue, 11 Dec 2012 08:18:19 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:46609Ian Yates<p>Great post and excellent examples :)</p>re: Joins in single-table querieshttp://sqlblog.com/blogs/rob_farley/archive/2012/12/11/joins-in-single-table-queries.aspx#46627Wed, 12 Dec 2012 13:43:39 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:46627Matt Velic<p>Very nice post, Rob. Love it!</p>Filegroups and Non-Clustered Indexeshttp://sqlblog.com/blogs/rob_farley/archive/2012/12/11/joins-in-single-table-queries.aspx#48188Tue, 12 Mar 2013 00:20:16 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:48188Rob Farley<p>Let’s start with some basics and then jump in a bit deeper, for this post to go with the 40th T-SQL Tuesday</p>