On Thu, Mar 12, 2015 at 12:11 PM, Christof Wollenhaupt < [email protected]> wrote:
> > > > 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. > ---------------------- Now I see your point. I call that a staging system where you bring every type of system's data into the mash pit and determine what needs to be updated in the Data Warehouse. 100% agree on simple recovery here. Use correctly? Wide range of correct answers there. Our ERP system considers the database to be just a data store with no intelligence associated with it. Everyone of our secondary apps for the business have their own db and use sprocs for all interaction with the api. The DW is only a staging but we advertise that in the db's name so we are not killing ourselves. We also have numerous cubes depending on the business type. Knowing how to allocate tempdb(s) is a nightmare across 5 instances of a prod server and I think I know what I am doing. Tweaking 3 different SSRS memory environments for 3 different major systems / instances is another joy. -- Stephen Russell Sr. Analyst Ring Container Technology Oakland TN 901.246-0159 cell --- 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/cajidmyj40yz-xqxe0maqwq5xpuo63gqmmoely7wsx1rqrr2...@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.
