Tuesday 11:25 AM: Using Ranking and Windowing Functions in SQL Server 2005
SQL Server 2005 adds the functionality of a Ranking expression that can be added to your resultset that is based on a ranking algorithm being applied to a column that you specify. This will come in handy in .NET applications for paging and sorting in a grid as well as many other scenarios. We will explore the ROW_NUMBER() function which assigns a running count to each row and compare it to RANK() and DENSE_RANK(). Use these functions to solve complex SQL Problems. Then we will look at custom percentile ranking using NTILE() and look at business and adacemic applications of NTILE. Lastly we will apply windowing functions to all of the 4 ranking functions with PARTITION BY to perform hard code aggregate functions
