Does anyone know how to handle tera bytes of data using Sql Server 2000. Specially for retrieving data in sql statements. I have learnt about partitioning views ... any other ways and the best ways of using partitioning views will be highly appreciated.

Regards,

Harris Moin