Shrinking causes fragmentaion

• beejug1983

  SSCertifiable

  Points: 6491

  More actions

  July 25, 2011 at 8:30 pm

  #244804

  Hi,

  How shrinking causes fragment level to increase ?

  I know when we shrink the db it increases the fragment level but how it increases ?

  Thanks in advance.

• Welsh Corgi

  SSC Guru

  Points: 116520

  More actions

  July 25, 2011 at 8:48 pm

  #1358224

  http://blogs.msdn.com/b/sqlserverstorageengine/archive/2006/06/13/629059.aspx

  http://sqlserverpedia.com/blog/sql-server-bloggers/sql-server-%E2%80%93-shrinking-database-is-bad-%E2%80%93-increases-fragmentation-%E2%80%93-reduces-performance/

  For better, quicker answers on T-SQL questions, click on the following...
  http://www.sqlservercentral.com/articles/Best+Practices/61537/

  For better answers on performance questions, click on the following...
  http://www.sqlservercentral.com/articles/SQLServerCentral/66909/