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.
    a011010, Dec 22, 2009
    #2

  2. Luis Martin Moderator

    Yes, fragmentation.
    Luis Martin, Dec 22, 2009
    #3

  3. MohammedU New Member

    Can you be more specifie what effect you asking?
    MohammedU, Jan 6, 2010
    #4

  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.
    moh_hassan20, Jan 8, 2010
    #5

Share This Page