> > Temp data is written into the database? I think you mean Transactions
are written to the .log of the database unless you override that. What I mean is data temporarily being loaded into the database. I've often seen import processes implemented by loading data into a processing table in the main database, then have some process go through this data to integrate this into the actual tables. The proper way to handle this would be to load that raw input data into a separate database that uses simple recovery. Then process the table and only update those records in the main database that need to be updated. The biggest problem of MS SQL server is that it's so easy to use, but so hard to use correctly. MS made SQL server so accessible to developers and users that hardly anyone operating an MS SQL server has any clue what they are doing. -- Christof --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/CAL4QJhgJ=T0jm-82BWRX_5Pb_3w20g+sRvYSzFR=ke755cj...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
