Christian,
Terra server is the biggest public site that I know of. There are many huge websites, such as BarnesandNobel.com, that are using SQL Server. Check out the SQL Server site at Microsoft.com/sql.
Also, try posting a message in the public newsgroups.
-Mike