Home Forums SQL Server 7,2000 Administration How do I do reindexing & defragmentation of my database RE: How do I do reindexing & defragmentation of my database

  • February 5, 2008 at 4:23 am

    #775040

    mjafar (2/5/2008)

    Nowadays my database is running very slow.

    So I have decided to do re indexing & defragmentation.

    I have did shrinking of database.

    Here first time I am doing re indexing & defragmentation of database.

    How do I go for this. Is there any procedure for this task.

    What are the commands/stored proc, steps take to consider.

    please reply soon __.____._

    Regard

    Majid

    This you have posted in the 2005 forums as well http://www.sqlservercentral.com/Forums/Topic451520-357-1.aspx.

    Is this a 2000 or 2005 server? (the syntax for reindexing and defragmenting is different).

    Regards,

    Andras

    Andras Belokosztolszki, MCPD, PhD
    GoldenGate Software