Home Forums SQL Server 2008 SQL Server 2008 - General Problem in 1 Billion Records Table RE: Problem in 1 Billion Records Table

  • March 25, 2013 at 2:19 am

    #1600194

    Si Thu (3/24/2013)

    Hi,

    I have one huge table which has 1Billion records. I tried to delete unnecessary records but it took a lot of time to delete and the delete was unsuccessful.

    Now my data is 26,491,552KB and index 20,569,168KB. Now inserting and updating process become very slow. What is the best way to handle the table to make it faster read and write access.

    Thanks in advance.

    Post the ddl for the table, including all indexes. A sample of your data would be helpful too.

    “Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw

    For fast, accurate and documented assistance in answering your questions, please read this article.
    Understanding and using APPLY, (I) and (II) Paul White
    Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden