Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  General SQL Server Forums  Database Design and Application Architecture  Batch Table details please

Author  Topic  abcefg Starting Member 16 Posts Posted - 2009-03-14 : 09:25:40 I guess! Can we handle this issue with Batch processing with adding Timestamp field with every table and use that MAX (Timestamp) and save this into Batch table. And every next run read MAX (Timestamp) from table and use that timestamp in where clause. In this way Query will run on Limited numbers of row. Neither run on Terabytes of records! Well friend. Trans-DB was not designed with good technique. I can make changes into it. If Required? Is there any proper and good solution you know, please share with me. (Keep in mind we don’t use SSIS, we do see SQL-Scripts. We are planning to migrate on TD soon. Till then have to see the issues of MS-SQL server. ?)