Post reply

Billions of Rows in Database Tables

  • February 12, 2006 at 9:11 pm

    #110978

    Hi Everyone,

    I am going to design a physical database and few of the tables are going to have more than billions of records in each table. This new project will be used SQL Server 2005 enterprise edition and I would like to know that how much reliable the SQL Server 2005 server in handling billions of rows in tables and how the performance would effect while database is growning. If any one has experience with big databases like billions of rows database please share your experience me and suggestions. I really appreciate your time.

     

    Thanks,

    BK

  • February 14, 2006 at 7:20 am

    #620668

    I have several databases that have more than 2.8 billions of records in some of the tables in sql 2000. It works well. For these tables, index design is very important. I have only clustered primary key on these tables and the PK is composed by the columns that most queries can use.  

    Sql 2005 supports table partition, which makes it easier to manage and support big tables with billions of records.

     

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply