With SQL Server 2005, SQL Server introduced some of SQL’s window functions, that apply, not to the full set, but a partitioned ‚window‘. Although the ROW_NUMBER, RANK, NTILE and DENSE_RANK bring great power to TSQL, the full versatility will not be available until SQL Server delivers the full implementation. As usual, Robert Sheldon explains all.