Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2011
    Posts
    47

    Unanswered: how to optimize DB with command?

    is there any command to optimize a database for eg: after 1 month if DB is full of mess then with one command every thing will be in sorted order or something like that to increase the efficiency and speed, is there any thing like that in MSSQL 2005?

  2. #2
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Dbcc reindex?
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  3. #3
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Quote Originally Posted by navedjobs View Post
    if DB is full of mess
    Can you clarify what you mean by "mess"?
    George
    Home | Blog

Posting Permissions

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