Home Forums SQL Server 2005 SQL Server 2005 Performance Tuning Performance Tuning - How do you go about tuning a SQL Server query? RE: Performance Tuning - How do you go about tuning a SQL Server query?

  • February 17, 2010 at 6:24 am

    #1120015

    Make sure that the queries are written so that they can use indexes and do no unnecessary work. Make sure that the indexes support the queries.

    Test question? Interview question?

    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