I've used a software tool from Grid Tools called Datamaker that worked quite well.

I've used this product on data sets between 20,000 and 850,000,000 rows.

I've also seen a...

I found this link to SS 2005 Ranking functions:

http://technet.microsoft.com/en-us/library/ms189798%28v=sql.90%29.aspx