Can I drop indexes during large (60 million row) SQL 2005 Insert!
I am doing an insert from one server to another...the source table is 60 million records, and it is taking forever....I need to drop the indexes (there are 10 of them) on the destination table, but am only about 19 million records through the insert. Is this possible - i.e. can I open a separate session in SQL Management Studio and drop the indexes?
Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.