Duplicate a table/view

• nelsonviggiani

  SSC Enthusiast

  Points: 171

  More actions

  January 23, 2008 at 10:23 am

  #185842

  I have a view with 5 milions records and I need to copy all that data into a table, so I use select into and/or insert into and it´s taken too long to complete more then 2 hours, my question is, there is any other way to do this task faster?

  thanks

  Nelson

• Donn Polix

  Default port

  Points: 1453

  More actions

  January 23, 2008 at 10:45 am

  #770984

  Bulk insert with tablock hint will improve performance.

  Still several factors to be considered, physical placements of data, index, tempdb files, fast disk subsystem..etc.

  _____________
  Donn Policarpio