JOIN simplification in SQL Serverhttp://msmvps.com/blogs/robfarley/archive/2008/11/09/join-simplification-in-sql-server.aspxThis is another of my tips/techniques that I demonstrated recently. It is not a new SQL Server 2008 feature - it works just fine in older versions - I demonstrated it running on SQL Server 2005 but using SQL Server 2008 Management Studio. [Note: It&#39;senCommunityServer 2008.5 SP2 (Build: 40407.4157)re: JOIN simplification in SQL Serverhttp://msmvps.com/blogs/robfarley/archive/2008/11/09/join-simplification-in-sql-server.aspx#1654322Mon, 17 Nov 2008 06:11:25 GMTd67277c4-116b-43f1-b688-e9ef184ea916:1654322Rajarshi Das<p>Good article and helps definately to increase performance</p> <div style="clear:both;"></div><img src="http://msmvps.com/aggbug.aspx?PostID=1654322" width="1" height="1">Unique Indexes with GROUP BYhttp://msmvps.com/blogs/robfarley/archive/2008/11/09/join-simplification-in-sql-server.aspx#1653562Sun, 09 Nov 2008 07:30:39 GMTd67277c4-116b-43f1-b688-e9ef184ea916:1653562Rob Farley<p>Indexes are great, but if you don&#39;t understand the significance of unique indexes, then you&#39;re</p> <img src="http://msmvps.com/aggbug.aspx?PostID=1653562" width="1" height="1">