Thanks for your replies.

The average is a moving average, in the sense that I need to take into consideration last 5 instances only.

thanks in advance.

Thanks for taking the time to answer.

I agree with the first two. Regarding the third, I do not see any reference in BOL regarding REINDEX

consolidating data into one file, when...

Thank you. You are on mark.

It makes sense that when SQL Server is creating a new index, it creates it as object 99, and when finally complete, probably assigns...

Thanks for the info. Stopping that service helped. Apparently that is not even used.

I think I understand what is going on here. When I dropped the clustered index, it has to touch all the non-clustered indexes to update the previous clustered key portion...

We have used SANS from EMC (Symmetrix) before for our databases. They have a custom RAID configuration RAID S. But on the database front you would still have to separate...

Brian & Allen:

Thanks for the information. I am doing something on the same lines. I just want to make sure this is the right way to do it. May be...

I agree with vladan 100%. We have ~ 300GB database on a server with 6 X 144 GB drives in RAID 5. I think it was done this way to...

The following script does the export. You can write on the same lines to import into other server.

'-- Srikanth Goli

'-- 8/5/03

'-- Export or Import DTS packages from/into SQL Server in...