Will SQL Server 2000 be able to use indexes in a view over a union of a view across linked servers?

Without knowing more details about your setup, I think your preference should be to leave the data for the two systems in place regardless of whether queries through linked servers end up using indexes. The way you have things set up sounds reasonable given the circumstance. However, I would think since you know that you need to combine the two data sets, I'd consider migrating the data from one server to the other, provided the one server can handle both transaction loads.

This should provide better performance overall for your queries I would think. Again, though, it would greatly depend on what your server and network infrastructure is like.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.

Related Questions