Four-part names
-
I agree however, regardless of the platform, I would still have gotten the job as the Database that they require me to design is on on SQL Server 2000. I just wanted to express my thoughts about some of the crappy RDBM's platforms that are out there!
Fortunately for this company, the next version of this Progen product will be on.....can everyone guess? Drum role please................................................................................................................................You got it! SQL Server 2000 wins!
-
In addition to what has already been posted. I transfer 70+ tables (6+ GB) daily from a third party system and understand your frustration.
These tables are used for reporting and is sufficient for most users. If any system requires upto date data then I use the OPENQUERY method to get selective data or use DTS if the table is large, DTS is way faster than OPENQUERY. Also, as mentioned, I find that transfering data into staging tables works best for large volumes.
Far away is close at hand in the images of elsewhere.
Anon. -
Naturally this Database will grow so the decision to copy the tables overnight to the SQL Server Database will be beneficial in terms of performance.
David Burrows,
70 Tables? The Database that I'm talking about for this thread is only copying 7 tables overnight. However that could change in future as more requirements come through from the business. Nevertheless, I'm glad to hear that I can reach upto 70 tables in future
Viewing 3 posts - 16 through 17 (of 17 total)
You must be logged in to reply to this topic. Login to reply