SQL Server Performance

Shrinking database

Discussion in 'General DBA Questions' started by a011010, Dec 22, 2009.

  1. a011010 New Member

    if i shrink sql server 2005 database, will it affect on indexes.
  2. Luis Martin Moderator

    Yes, fragmentation.
  3. MohammedU New Member

    Can you be more specifie what effect you asking?
  4. moh_hassan20 New Member

    avoid shrinking database , because it has negative effect on index and performance
    search in the forum , and you find many posts here that disused that effect.

Share This Page