http://mschnlnine.vo.llnwd.net/d1/Dev/App_Themes/C9/images/feedimage.pnghttp://channel9.msdn.com/posts/Dan/C9-Bytes-SQL-Server-Rank-with-Stephen-Forte/C9 Bytes: SQL Server Rank() with Stephen Fortehttp://channel9.msdn.com/posts/Dan/C9-Bytes-SQL-Server-Rank-with-Stephen-Forte/en-usSat, 07 Jun 2008 17:31:25 GMTSat, 07 Jun 2008 17:31:25 GMTEvNet (EvNet, Version=1.0.3608.3122, Culture=neutral, PublicKeyToken=null)<P>Thanks, yes, lots more coming, we probably have at least another five from TechEd :)</P>http://channel9.msdn.com/posts/Dan/C9-Bytes-SQL-Server-Rank-with-Stephen-Forte/?CommentID=408370Sat, 07 Jun 2008 17:31:25 GMThttp://channel9.msdn.com/posts/Dan/C9-Bytes-SQL-Server-Rank-with-Stephen-Forte/?CommentID=4083700http://channel9.msdn.com/408370/WebViewBug.aspx?EVT=0Thanks, yes, lots more coming, we probably have at least another five from TechEd :)Dan Fernandez0http://channel9.msdn.com/408370/Trackback.aspxI like this new format of very short videos that focus on 1 feature. Are there more <I>C9 Bytes</I> planned?http://channel9.msdn.com/posts/Dan/C9-Bytes-SQL-Server-Rank-with-Stephen-Forte/?CommentID=408320Sat, 07 Jun 2008 12:25:43 GMThttp://channel9.msdn.com/posts/Dan/C9-Bytes-SQL-Server-Rank-with-Stephen-Forte/?CommentID=4083200http://channel9.msdn.com/408320/WebViewBug.aspx?EVT=0I like this new format of very short videos that focus on 1 feature. Are there more C9 Bytes planned?Tommy Carlier0http://channel9.msdn.com/408320/Trackback.aspx<P>A great option that must appear in SQL standard as well and perhaps thats why its not implemented by other RDBMS vendors, in an effort to keep the SQL staement set as close to the standard as possible.</P> <P><BR>Same functionality can be introduced in most databses through a series of SQL statements or as an embeded function.</P> <P><BR>Unless part of SQL standard, even such good additions come at a price. In a query intensive environment, where a person is likely to enter more than 5-10 rank queries per day, likt the Olympics case for instance, if the underlying database is changed to or changed from SQL server, he is likely to find himself in trouble while adopting to changes.</P>http://channel9.msdn.com/posts/Dan/C9-Bytes-SQL-Server-Rank-with-Stephen-Forte/?CommentID=408125Fri, 06 Jun 2008 19:08:21 GMThttp://channel9.msdn.com/posts/Dan/C9-Bytes-SQL-Server-Rank-with-Stephen-Forte/?CommentID=4081250http://channel9.msdn.com/408125/WebViewBug.aspx?EVT=0A great option that must appear in SQL standard as well and perhaps thats why its not implemented by other RDBMS vendors, in an effort to keep the SQL staement set as close to the standard as possible. Same functionality can be introduced in most databses through a series of SQL statements or as an&#8230;umer_a0http://channel9.msdn.com/408125/Trackback.aspx