Channel 9

Entries:
Comments:
Posts:

Loading User Information from Channel 9

Something went wrong getting user information from Channel 9

MSDN

Activity Profile

Latest Achievement:

Loading User Information from MSDN

Something went wrong getting user information from MSDN

Visual Studio Achievements
Visual Studio Achievements

Latest Achievement:

Loading Visual Studio Achievements

Something went wrong getting the Visual Studio Achievements

C9 Bytes: SQL Server Rank() with Stephen Forte

Embed code for this video

Copy the code above to embed our video on your website/blog.

Close

Video format

Option selected may change based on video formats available and browser capability.

Close

Download

How do I download the videos?

  • To download, right click the file type you would like and pick “Save target as…” or “Save link as…”

Why should I download videos from Channel9?

  • It's an easy way to save the videos you like locally.
  • You can save the videos in order to watch them offline.
  • If all you want is to hear the audio, you can download the MP3!

Which version should I choose?

  • If you want to view the video on your PC, Xbox or Media Center, download the High Quality WMV file (this is the highest quality version we have available).
  • If you'd like a lower bitrate version, to reduce the download time or cost, then choose the Medium Quality WMV file.
  • If you have a Zune, WP7, iPhone, iPad, or iPod device, choose the low or medium MP4 file.
  • If you just want to hear the audio of the video, choose the MP3 file.

Right click “Save as…”

  • High Quality WMV (PC, Xbox, MCE)

    File size

    62.7 MB
  • MP3 (Audio only)

    File size

    1.6 MB
  • MP4 (iPod, Zune HD)

    File size

    10.8 MB
  • Mid Quality WMV (Lo-band, Mobile)

    File size

    12.8 MB
  • WMV (WMV Video)

    File size

    216.0 B
Stephen Forte demonstrates the little-known SQL Server Rank() statement and how it can be used to easily display categories and subcategories of Ranking data.

Follow the Discussion

  • umer_aumer_a Mario be on XBOX one day.

    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.


    Same functionality can be introduced in most databses through a series of SQL statements or as an embeded function.


    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.

  • Tommy CarlierTommyCarlier Widen your gaze
    I like this new format of very short videos that focus on 1 feature. Are there more C9 Bytes planned?
  • Dan FernandezDan

    Thanks, yes, lots more coming, we probably have at least another five from TechEd Smiley

Remove this comment

Remove this thread

close

Comments Closed

Comments have been closed since this content was published more than 30 days ago, but if you'd like to continue the conversation, please create a new thread in our Forums,
or Contact Us and let us know.

More posts in this blog

See More

Related posts

Creative Commons License

© 2013 Microsoft. Except where designated as licensed by
Creative Commons Attribution-Noncommercial-No Derivative Works 3.0 License,
Microsoft reserves all rights associated with the materials on this site.