Recent content by ohchaos

  1. O

    Fast and safe way to delete large number of records

    It worked. This is what I was looking for. Thank you so much.
  2. O

    Fast and safe way to delete large number of records

    Rob is correct. Your requirements are really quite vague and any advice we give will have to make far too many assumptions about what you are trying to accomplish. Thank you so much for the code. I am not familiar with 4GL. I need to join two tables to find the orphan records. In MS SQL, this...
  3. O

    Fast and safe way to delete large number of records

    Hello, I need to delete lots of records which is half of the big table (over 60 million records) joining the other table in other database. I can write the delete statement, but wan to run it fast and more importantly do commit after deleting1000 records to avoid the blocking. How can I do...
Top