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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Where is it

Author  Topic 

elwoos
Master Smack Fu Yak Hacker

2052 Posts

Posted - 2003-10-20 : 11:57:39
If I have two servers A and B. A has all the data and B has views on the data in A, where is all the porcessing done? Is it on Server A or Server B or a combination?

thanks

Steve no function beer well without

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2003-10-20 : 12:17:23
Well server A would have to do most of the work since it is the one with the data. But server B would too since it needs to figure out execute plans and thinks like that.

Tara
Go to Top of Page
   

- Advertisement -