Hi Sergey,
The application is not ours it belongs to a third party. So we cannot touch any indexes. So we thought of culling their sql database and copying the data to another db where we use our reporting programs.


>Hi Fred,
>
>It's not clear from your post why your applications gets slower. Maybe all you need to speed it up, is to create some additional indexes?
>If you still want to split data between multiple table, consider using Views or Partitioned Views.
>
>>I have 2 Databases running sql 2000, they are on different machines. DB1 is attached to an application, this application starts to slow down when the data in the DB1 tables grows, it has more than 24 months data.
>>
>>So what we want to do is to only leave last 12 months data in DB1 and have all the data in DB2. How do we update DB2 from DB1 with the latest changes and cull data in db1.tables more than 12 months old?
>>
>>Do we use Mirroring or do we write a SP. can anyone help me ?