Hi, While our current server is at its maximum in hardware terms and can hardly support the the database usage in performance terms anymore, we are planning to use a the federated database concept and set up a second server. the database can easily be split in several funtional areas and therefore we want to put complete tables on the second server (is this wise?) and create a partitioned view for each table. I am wondering where to put the stored procedures that makes us of these tables to gain as much performance as possible. Should they reside on the 2nd server and called from a stored procedure on the 1st server (so application does not need to be changed), or can they just stay on the 1st server and simply use the partitioned view? Any help is appreciated!