Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2004
    Posts
    55

    Unanswered: Question on sqlmaint scripts

    New to SQL Server.

    I am looking at some legacy sqlmaint scripts.

    If I don't see the switches

    ReblIdx

    or

    UpdOptiStats

    Does that mean that there are no database reorgs and no update system
    catalog statistics being done?

    The rebuild index switch is SQL Server speak for a reorg correct?

    Thanks in advance.

    Gerry

  2. #2
    Join Date
    May 2003
    Posts
    60
    If by "The rebuild index switch is SQL Server speak for a reorg correct?" you mean reorganinzing the data pages similiar to what a dbcc shrinkdatabase does then the answer is no.

    The -ReblIdx switch refers to rebuilding indexes.

    From BOL: -RebldIdx free_space

    Specifies that indexes on tables in the target database should be rebuilt by using the free_space percent value as the inverse of the fill factor. For example, if free_space percentage is 30, then the fill factor used is 70. If a free_space percentage value of 100 is specified, then the indexes are rebuilt with the original fill factor value.

    best regards

  3. #3
    Join Date
    Mar 2004
    Posts
    55
    I am trying to determine if any reorgs have been done. What flag/switch in the sqlmaint should I be looking for?

Posting Permissions

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