Unique Indexes with GROUP BY

Unique Indexes with GROUP BYhttp://msmvps.com/blogs/robfarley/archive/2008/11/09/unique-indexes-with-group-by.aspxIndexes are great, but if you don't understand the significance of unique indexes, then you're potentially missing out on some decent performance gains. I've been meaning to write this blog post for a long time. This is material that I'veenCommunityServer 2008.5 SP2 (Build: 40407.4157)facility9 » Links for the weekhttp://msmvps.com/blogs/robfarley/archive/2008/11/09/unique-indexes-with-group-by.aspx#1654231Sun, 16 Nov 2008 02:25:34 GMTd67277c4-116b-43f1-b688-e9ef184ea916:1654231facility9 » Links for the week<p>Pingback from  facility9 » Links for the week</p> <img src="http://msmvps.com/aggbug.aspx?PostID=1654231" width="1" height="1">JOIN simplification in SQL Server - Rob Farleyhttp://msmvps.com/blogs/robfarley/archive/2008/11/09/unique-indexes-with-group-by.aspx#1653563Sun, 09 Nov 2008 07:32:43 GMTd67277c4-116b-43f1-b688-e9ef184ea916:1653563JOIN simplification in SQL Server - Rob Farley<p>Pingback from  JOIN simplification in SQL Server - Rob Farley</p> <img src="http://msmvps.com/aggbug.aspx?PostID=1653563" width="1" height="1">