• How about UPDATEUSAGE and CHECKDB?? Do we need them?

    when we execute any sql or stored proc will the results get cached, if so is it cached in the disk or memory?

    In what order we have to run the following:

    DBCC Reindex, optimizations maint plan and Integrity checks

    I greatly appreciate all your responses. Thanks!!