... darkrealms ...

Forums before death by AOL, social media and spammers... "We can't have nice things"

comp.databases.ms-sqlserver

Notorious Rube Goldberg contraption

19,505 messages

[ << oldest | < older | list | newer > | newest >> ]

Message 17,528 of 19,505

David Greenberg to All

When do I need to reorganize an index on

11 Jun 09 11:54:50

   From: davidgr@iba.org.il   
      
   Hi   
      
   I use Sql Server 2008.   
      
   1. After I truncate a table, is it necessary to recreate it's keys and   
   indexes ?   
      
   1. Is it necessary to run "DBCC DBREINDEX" to reorganize a table if the   
   only way it  receives data is by import from an external source after   
   the table has been truncated ?   
      
   Thanks !   
      
   David Greenberg   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)

[ << oldest | < older | list | newer > | newest >> ]