Monthly Archives: December 2008

>T-SQL: Top N Rows Per Group

>The following will return the top 10 players who hit the most home runs per year since 1990. The key is to calculate the “Home Run Rank” of each player for each year. selectHRRanks.*from(Selectb.yearID, b.PlayerID, sum(b.Hr) asTotalHR,rank() over (partition by … Continue reading

Posted in Data Access, programming | Leave a comment

>ASP.NET Session Timeouts

> In ASP.NET there are lots of timeouts. In this blog entry I will be covering in great detail Session timeout due to the complexity of the issue and the fact that I can never remember where all the setting … Continue reading

Posted in | Leave a comment