Home Forums SQL Server 7,2000 Performance Tuning OPENROWSET select statement performance -- runs in 4 seconds on test server vs. 3 minutes on production server. RE: OPENROWSET select statement performance -- runs in 4 seconds on test server vs. 3 minutes on production server.

  • August 29, 2008 at 5:09 pm

    #865321

    Is the network route the same between the dev server and oracle server and the prod server and oracle server?

    Why are you using dynamic SQL?

    Jack Corbett
    Consultant - Straight Path Solutions
    Check out these links on how to get faster and more accurate answers:
    Forum Etiquette: How to post data/code on a forum to get the best help
    Need an Answer? Actually, No ... You Need a Question