I am about to add a table to our database that may contain anywhere from 2.5 billion to 5 billion records. I never had to deal with a table this large and I was wondering if anyone could give me some advice on what to look out for as far as performance goes.

and just out of curiosity, is there a limit to how many rows a table can hold in SQL 2000