http://blogs.msdn.com/craigfr/archive/2006/08/16/702828.aspxThe following table summarizes the characteristics of the three physical join operators which I described in my three prior posts. Nested Loops Join Merge Join Hash Join Best for … Relatively small inputs with an index on the inner table on the join key.enCommunityServer 2.1 SP1 (Build: 61025.2)http://blogs.msdn.com/craigfr/archive/2006/08/16/702828.aspx#702912Wed, 16 Aug 2006 22:29:39 GMT91d46819-8472-40ad-a661-2c78acb4018c:702912Bart Duncan's SQL WeblogCraigFr has a great series of posts in his blog describing the difference between the various logical...http://blogs.msdn.com/craigfr/archive/2006/08/16/702828.aspx#751287Wed, 13 Sep 2006 02:34:59 GMT91d46819-8472-40ad-a661-2c78acb4018c:751287Ward Pond's SQL Server blogEvery once in awhile, I get an opportunity to look around for new and interesting things to read.&amp;amp;nbsp;...http://blogs.msdn.com/craigfr/archive/2006/08/16/702828.aspx#751356Wed, 13 Sep 2006 03:25:28 GMT91d46819-8472-40ad-a661-2c78acb4018c:751356Ward Pond's SQL Server blogEvery once in awhile, I get an opportunity to look around for new and interesting things to read.&amp;amp;nbsp;...http://blogs.msdn.com/craigfr/archive/2006/08/16/702828.aspx#4277339Tue, 07 Aug 2007 17:37:59 GMT91d46819-8472-40ad-a661-2c78acb4018c:4277339SQL Server Transact-SQL (SSQA.net)<p>Since the beginning of learning SQL Server I'm pretty much confused with JOIN conditions that defines</p> http://blogs.msdn.com/craigfr/archive/2006/08/16/702828.aspx#9270153Sat, 03 Jan 2009 10:38:57 GMT91d46819-8472-40ad-a661-2c78acb4018c:9270153chineseboy<p>HI craigfr,Can you talk about the inside of the Sort operator.</p> http://blogs.msdn.com/craigfr/archive/2006/08/16/702828.aspx#9574395Wed, 29 Apr 2009 00:50:36 GMT91d46819-8472-40ad-a661-2c78acb4018c:9574395Craig Freedman's SQL Server Blog<p>In this post, I want to take a look at how two seemingly unrelated features of SQL Server can interact</p>