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 |
|
jeeno70
Starting Member
2 Posts |
 Posted - 2009-11-12 : 14:17:52
|
| we are running sqlserver 2000 database more than 10 years. the data is growing day by day . size of the database is around 50GB. performance is not good. any one provide the slotion for datawarehousing for this database. How to split the database into two datbase in sqlserver 2000. |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2009-11-12 : 15:39:33
|
| start by looking at your indexes. when were they last rebuilt? if you have long running queries, maybe you need to create new indexes...50 GB is not tooo big |
 |
|
|
|
|
|
Database split