Home Forums SQL Server 7,2000 Strategies updating 1,000 records takes 5-6 minutes I would like to decrease the time that takes RE: updating 1,000 records takes 5-6 minutes I would like to decrease the time that takes

  • itsmeman (1/5/2010)


    what advice would you all have to not using cursors if you

    have sensitive data that needs to be checked to maintain its integrity?

    I believe that SQL 2000 had a technology called 'Foreign Keys' to enforce something it called 'referential integrity.' Check constraints, triggers and even data types were available back then.