All of us hear about MySpace. It has become the site with the highest traffic. It now runs on ASP.Net and SQL 2005. You can read the story about how the folks at MySpace handled their exponential growth(40 billion page views a month), the problems they encountered and how the site architecture evolved from a few thousand users to a millions of users. It is an awesome read.