Home Forums SQL Server 2014 Administration - SQL Server 2014 DBA -tasks and solutions RE: DBA -tasks and solutions

  • February 12, 2016 at 4:54 am

    #1858289

    PiMané (2/12/2016)

    1. DEFRAG/REBUILD INDEXES

    - Can create a maintenance task on SQL Server (it does this out of the box)

    Please don't. The maintenance task is braindead. Use Ola's scripts, use Minion reindex, use any of the other excellent rebuild scripts available over the maintenance task.

    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