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.
| Author |
Topic |
|
khalik
Constraint Violating Yak Guru
443 Posts |
 Posted - 2002-01-15 : 22:15:44
|
| hi i need all u expert to suggest me...i have a huge base in oracle, sql very huge...i have to maintain a snapshot of both the database (selected data)for every month and generate MIS reports..... i dont know i am talking about datawarehouse....? so i dump data every month in sql 2000 server.... should i havediffrent database for every month or same database with diffrent tables...issues to consider...1. performances2. handling3. coding4. reterivaland any more i have Compaq server PIII 1.3g mhz with a lot of hard disk and 512 ram and SQL 2000 loaded.... any help or advice is welcomethanks |
|
|
|
|
|
Expert Advice