Home Forums SQL Server 2008 T-SQL (SS2K8) which way should I write JOIN Query ? RE: which way should I write JOIN Query ?

  • November 23, 2015 at 2:48 am

    #1841617

    KcV (11/23/2015)

    (After writing SP i do Optimizing using Database Tuning Adviser ) is it OK ?

    I am not sure you should completely rely on DTA for performance optimisation that too at SP level . It is better to have design and development standards and practises, and tune the query when it is required.

    But using DTA for learning is fine though.

    ----------------------------------------------------------------------------------------------------------------------------------------------------
    Roshan Joe

    Jeff Moden -Forum Etiquette: How to post data/code on a forum to get the best help[/url]