January 13, 2010 at 5:38 pm
I am trying to load data of size nearly 1TB which has 12 indexes on each tables which includes 4 tables. How do i do this..
1.Disable indexes (on 4 tables together)
2.Bulk Insert (import wizard)
3.Enable indexes
January 13, 2010 at 7:24 pm
January 13, 2010 at 7:28 pm
Use Alter Index statement Disable option-->
DISABLE (http://technet.microsoft.com/en-us/library/ms188388.aspx)
Marks the index as disabled and unavailable for use by the Database Engine. Any index can be disabled. The index definition of a disabled index remains in the system catalog with no underlying index data. Disabling a clustered index prevents user access to the underlying table data. To enable an index, use ALTER INDEX REBUILD or CREATE INDEX WITH DROP_EXISTING.
Read-->http://decipherinfosys.wordpress.com/2007/09/25/enabling-and-disabling-an-index-in-sql-server-2005/
MJ
January 14, 2010 at 4:50 am
Every time i import data (more than 100 million records) through wizard i get comminication link failure error from one server to another, is there an easy ans fast way to import data.
how do i BULKINSERT keeping the identity column in batches, i feel this may load faster.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply