Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2008
    Posts
    3

    Question Unanswered: Command for rebuild and reorganize indexes in MSSQL server2000

    Hi,
    I have a script to rebuild and reorganize indexes for sybase i.e reorg rebuild index... like command i have. Now i want similar command for MSSQLSqlserver.plz help me.

  2. #2
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Testimonial:
    pootle flump
    ur codings are working excelent.

  3. #3
    Join Date
    Feb 2004
    Posts
    8
    I have a stored procedure that could help you with this. The stored procedure does index rebuild online or offline, index reorganization, statistics update, index reorganization and statistics update or nothing based on fragmentation level, LOB existence and index size.
    http://blog.ola.hallengren.com/blog/...1/3440068.html

    Ola Hallengren
    http://ola.hallengren.com

Posting Permissions

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