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 1:26 am

    #1645859

    Koen Verbeeck (8/29/2013)

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

    You are absolutely right, but without knowing wich queries are executed, you can't create the needed indexes, choose a proper partition schema, etc. :-P. Sounds like the egg and chicken discussion:w00t:

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **