Home Forums SQL Server 2008 SQL Server 2008 Performance Tuning Improving the performance of a Big table RE: Improving the performance of a Big table

  • August 29, 2013 at 4:01 am

    #1645904

    Koen Verbeeck (8/29/2013)

    HanShi (8/29/2013)

    You are not to be improving a table, but you need to improve the queries accessing that table.

    And how can you improve a query? By updating statistics, minimize logging, creating indexes, compress the data, partition the table, ... 🙂 😉

    Maybe, no, maybe, maybe, no.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass