Here is a great video on how TVGuide is leveraging MOSS 2007 enterprise features for its Online Video Guide (One of the MOSS projects that truly yours was involved along with a team of great folks here in U.S and India!):

Media Company’s Fast, Relevant Internet Video Search Drives Business

TV Guide took advantage of the growing interest in online video content by creating a new service for end-users to search primarily professionally produced video content through a video guide at www.video.tvguide.com. It chose Enterprise Search, an integrated part of Microsoft® Office SharePoint® Server 2007 that delivers fast, accurate results and a pleasant browsing experience to drive customer loyalty and to increase advertising revenue.

Streaming Video