Home Forums SQL Server 2005 SQL Server 2005 Performance Tuning how will you come to know which index is missing in a table of sqlserver 2005 RE: how will you come to know which index is missing in a table of sqlserver 2005

  • September 22, 2014 at 8:21 pm

    #1747277

    Rather than me regurgitating what has already been written, open up "Books Online" (the Help system for SQL Server) and lookup "Missing Indexes". Make sure that you understand the warnings and limits of the related features, as well.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)