SP Optimization.. for Fast Execution.

• DKSINGH

  SSC Eights!

  Points: 921

  More actions

  February 11, 2005 at 9:55 pm

  #66885

  Hi all,

  I am using a SP to the Explained task as below :

  Using BCP to transfer Data into temp table.

  Reading Data from temp table.

  Validating the Data. Like check of Duplicacy. Error Handling and all.

  This takes Lots of time to process the Loading.

  Can any one suggests how to optimize the performance ?

  Can i use indexing inside SP or better use Index Before Execution?

  Thanks

• Adam Machanic

  SSCoach

  Points: 15370

  More actions

  February 12, 2005 at 3:11 pm

  #541944

  Maybe?

  Sharing some code might shed some light on whether or not it can be optimized; but have you considered using DTS for this?

  --
  Adam Machanic
  whoisactive

• Frank Kalis

  SSC Guru

  Points: 111183

  More actions

  February 14, 2005 at 2:46 am

  #542011

  See if this helps:

  http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/incbulkload.mspx

  --
  Frank Kalis
  Microsoft SQL Server MVP
  Webmaster: http://www.insidesql.org/blogs
  My blog: http://www.insidesql.org/blogs/frankkalis/[/url]