http://blog.alecl.com/archive/tags/Creative/SQL+Server/default.aspxTags: Creative, SQL ServerenCommunityServer 2.1 SP2 (Build: 61129.2)http://blog.alecl.com/archive/2007/06/18/creative-queries.aspxMon, 18 Jun 2007 23:26:00 GMT022ae8cf-15ca-4180-8062-b150ad1660bf:3alecl0http://blog.alecl.com/comments/3.aspxhttp://blog.alecl.com/commentrss.aspx?PostID=3<P>Two interesting techniques I came upon:</P> <P><A class="" title="Using OVER() with Aggregate Functions" href="http://www.sqlteam.com/article/sql-sever-2005-using-over-with-aggregate-functions" target=_blank>http://www.sqlteam.com/article/sql-sever-2005-using-over-with-aggregate-functions</A></P> <P>Retrieve aggregate data using OVER(Partition by ...) rather than doing another join</P> <P><A class="" title="Using GROUP BY to avoid self joins" href="http://weblogs.sqlteam.com/jeffs/archive/2007/06/12/60230.aspx" target=_blank>http://weblogs.sqlteam.com/jeffs/archive/2007/06/12/60230.aspx</A></P> <P>Using GROUP BY in some cases to avoid a self-join</P> <div class = "shareblock"><strong>Share this post:</strong> <a title="Email Creative+Queries" href = "mailto:?body=Thought you might like this: http://blog.alecl.com/archive/2007/06/18/creative-queries.aspx&subject=Creative+Queries">Email it!</a> | <a href = "http://del.icio.us/post?url=http://blog.alecl.com/archive/2007/06/18/creative-queries.aspx&title=Creative+Queries" title="Submit Creative+Queries to del.icio.us" >bookmark it!</a> | <a href = "http://www.digg.com/submit?url=http://blog.alecl.com/archive/2007/06/18/creative-queries.aspx&phase=2" title="Submit Creative+Queries to digg.com">digg it!</a> | <a href = "http://reddit.com/submit?url=http://blog.alecl.com/archive/2007/06/18/creative-queries.aspx&title=Creative+Queries" title="Submit Creative+Queries to reddit.com">reddit!</a></div><img src="http://blog.alecl.com/aggbug.aspx?PostID=3" width="1" height="1">CreativeT-SQLSQL Server