From: hugo@perFact.REMOVETHIS.info.INVALID   
      
   On Wed, 20 Oct 2010 09:22:13 +0200, m wrote:   
      
   >Hello everybody,   
   >   
   >does anyone know what is the best practice for setting *.mdf autogrowth   
   >parameter?   
   >Database is now about 4GB big and shold be bigger for about 200MB every   
   >year.   
   >   
   >If I put 10% is that correct?   
   >   
   >Regards and thanks in advice   
   >   
      
   In addition to the reply by Iain Sharp - the best practice is to   
   manually grow the databases during off hours, and in large chunks at   
   once. Repeatedly growing in small chunks increases fragmentation.   
      
   --   
   Hugo Kornelis, SQL Server MVP   
   My SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)