Thanks oneilldo. I ran the query only find I am mistaken on the table width. Turns out the table is narrower than some other tables. Though there...
Thanks Med. Sounds good for the inserts. What about the udpates? Anyone have thoughts on bulk updates.
I am going to use a .Net or VB 6 client app to select data from one db, process the data according to business rules and insert into another db. The...
Chappy, good question. the data DOES need to be denormalized. We run numerous counts & computations off this table. It is more efficient to run...
I am getting slow times (3-7 days) to build a 2-3 million row table that is very wide (120+ fields). It is has a surrogate int Clustered index and...
Separate names with a comma.
