locked
DBCC SHRINKFILE EFFICIENCY ISSUE RRS feed

  • Question

  • The sql2005 database becomes more slowly since i used the "dbcc shrinkfile " command. The msdn said : the command will produce some fragment. it results in the efficiency problem.  Now how to optimize the sql2005? Many of the applications which run on the sql2005 report error. 

    What can i do to optimize the database?
    Does the "dbcc shrinkfile" produce index fragment or other fragment?

    Tuesday, September 1, 2009 3:15 AM

Answers