http://blogs.technet.com/b/dataplatforminsider/archive/2010/07/07/sql-server-2008-sp2-ctp-is-now-available-for-public-testing.aspxSQL Server 2008 SP2 CTP contains all the cumulative updates for SQL Server 2008, and fixes to issues that have been reported through our customer feedback platforms. These include supportability enhancements and issues that have been reported throughen-USTelligent Evolution Platform Developer Build (Build: 5.6.50428.7875)http://blogs.technet.com/b/dataplatforminsider/archive/2010/07/07/sql-server-2008-sp2-ctp-is-now-available-for-public-testing.aspx#3345496Wed, 21 Jul 2010 10:25:06 GMTd5e57398-b9ef-4490-9955-07cbb4e4a80d:3345496SQL Lion<p>T-SQL RowNumber() vs Rank() vs DenseRank() vs NTILE() | SQL Lion</p> <p>SQL Server comes with some magical words that make simple the life of a developer or DBA to a great extent. And these magic words are RowNumber(), Rank(), DenseRank() and NTile(). Follow the link to get more…</p> <p><a rel="nofollow" target="_new" href="http://www.sqllion.com/2010/07/ranking-functions/">www.sqllion.com/.../ranking-functions</a></p> <div style="clear:both;"></div><img src="http://blogs.technet.com/aggbug.aspx?PostID=3345496" width="1" height="1">