SQL 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 through Windows Error Reporting.
SP2 CTP applies to: SQL Server 2008 Enterprise Edition SQL Server 2008 Evaluation Edition SQL Server 2008 Developer Edition SQL Server 2008 Standard Edition SQL Server 2008 Web Edition SQL Server 2008 Express Edition SQL Server 2008 Workgroup Edition
SP2 is expected to release in CY 2010
Download SQL Server 2008 SP2 CTP
T-SQL RowNumber() vs Rank() vs DenseRank() vs NTILE() | SQL Lion
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…
www.sqllion.com/.../ranking-functions