SQL Server Fragmentation

• steve Veloudos

  Newbie

  Points: 1

  More actions

  April 19, 2005 at 7:46 pm

  #88724

  I have heard that a database will become fragmented quicker if you use Delete then Insert instead of Update SQL commands. Is this true? Does anyone have an article link about this?

  Thanks!

• Chris Hedgate

  One Orange Chip

  Points: 25041

  More actions

  April 20, 2005 at 12:48 am

  #553650

  Try my article here at SQLServerCentral: Fragmentation 101

  --
  Chris Hedgate http://www.hedgate.net/
  Contributor to the Best of SQL Server Central volumes
  Articles: http://www.sqlservercentral.com/columnists/chedgate/