Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2015

    Unanswered: Rebuilding Of Index

    I have 6 database in sql server 2008r2 which are 250gb + each databases has aproxmately 1000 tables out of which 400 tablels fragmentations is more than 60% .i have defragmented all the Index manually now the owner wants to create a mentance plan for rebuilding Indexes . since the size of databases are to large so How much time each plan will take for individual database

  2. #2
    Join Date
    Feb 2004
    In front of the computer
    Provided Answers: 54
    The SQL Server community has a lot of free and well supported software that handles tasks such as this.

    I would suggest that you use Ola Hallengren's excellent tool which does exactly what you have described.

    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts