• You also can add about

    1>Data, Log and tempDB file placement on disk for better performance

    2>Usage of bare SQL statements.

    3>How to select columns and order of the columns in index for better performance.

    4>How to avoid bottle necks of performance like cursors, GROUP BYs and many other

    5>How to avoid performance issues in execution plan like Key Lookups, Table scan, index scans.