Printable View
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
You can partition data across multiple servers using federated servers.
It's not something I've ever done but a server can manage each partition in effect. It's the ultimate in high performance for SQL Server I think.
Do you have TeraByte databases? Can I come and work for you, I work for a large company but never seen a database bigger than 200 Gig.
Have you got any hair left!!