From: esquel@sommarskog.se   
      
   m (web12master@gmail.com) writes:   
   > I need to increase tempdb database on SQL Server 2008 R2.   
   >   
   > Can I do it in business hours?   
   > Is there any negative inpact on the system?   
      
   If the service account does not have the Windows permission Perform Volume   
   Maintenance Tasks, SQL Server needs to clear all pages in the newly   
   allocated space, and that will take resources.   
   --   
   Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se   
      
   Links for SQL Server Books Online:   
   SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx   
   SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)