Results 1 to 2 of 2

Thread: Sql Server Optimization for Large Data

  1. Jul 24th, 2003, 05:54 AM #1
    harris_moin
    harris_moin is offline

    Thread Starter
    Member
    Join Date
    Aug 2002
    Location
    Pakistan
    Posts
    32

    Sql Server Optimization for Large Data

    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'll get life just for once so don't waste it .......
    Reply With Quote Reply With Quote
  2. Jul 25th, 2003, 09:57 AM #2
    London75
    London75 is offline
    Lively Member
    Join Date
    Apr 2002
    Location
    Manchester,UK
    Posts
    94
    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!!
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width