If you're like me and always change the default install directories, you've probably run into this. A workaround is here . Share this post: Email it! | bookmark it! | digg it! | reddit! Read More...

Two interesting techniques I came upon: http://www.sqlteam.com/article/sql-sever-2005-using-over-with-aggregate-functions Retrieve aggregate data using OVER(Partition by ...) rather than doing another join http://weblogs.sqlteam.com/jeffs/archive/2007/06/12/60230.aspx Read More...