Post reply

link or website for Performance tuning and optimizing query

  • December 14, 2009 at 4:02 am

    #217574

    hi

    can anubpdy tell me any

    link or website for Performance tuning and optimizing SQL 2005 query ?

    i need to learn this

    -------Bhuvnesh----------
    I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

  • December 14, 2009 at 5:18 am

    #1091868

    http://msdn.microsoft.com/en-us/library/ms979196.aspx

    http://www.sql-server-performance.com/

    and the list can go on....

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

  • December 14, 2009 at 5:22 am

    #1091870

    thanks

    but i am talking about tuning Sql queries

    -------Bhuvnesh----------
    I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

  • December 14, 2009 at 6:56 am

    #1091911

    I was going through one white paper recently and thought its good. A lengthy one but discusses lot of aspects with performance tuning.

    (May be more suited for a DBA and not developer as its not concentrated around tuning the queries only)

    http://technet.microsoft.com/en-us/library/cc966540.aspx#EDAA

    ---------------------------------------------------------------------------------

  • December 14, 2009 at 9:22 am

    #1092040

    Start with this two-part series. Finding the problem is more than half the battle.

    http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/

    I doubt there's a single, comprehensive site that covers everything. The links given earlier are good but that's far from everything. Read blogs, articles and performance questions here. Grant Fritchey's book (link in his sig) is a very good resource.

    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

Viewing 5 posts - 1 through 4 (of 4 total)

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