| Posted by sqlmatt on 07/17/07 16:53 
It is not explicitly stated, so I'll ask:
 Does each environment call the stored procedures with the exact same
 parameters?
 
 Does each environment call the stored procedure after a set of data is
 loaded?
 
 Do you have the execution plan for each scenario?
 
 If you explicitly update statistics for the system after the new data
 is loaded, does the execution time improve?
  Navigation: [Reply to this message] |