http://www.sqlservercentral.com/Articles tagged SQL Server 7, 2000, Distributed Queries, Replication posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)A monster book at 980 pages, it's written in 'how-to' format and has a ton of good material. Andy gave it the once over for us and reports back - see what he thinks! http://www.sqlservercentral.com/articles/Installation/reviewofsql2000fastanswers/959/2003/04/18http://www.sqlservercentral.com/articles/Installation/reviewofsql2000fastanswers/959/Middle tier applications often use a single database management system (DBMS) to store data, which can expose scaling limitations as the number of user requests increases. Caching, a technique used to increase application performance by copying data and then using the copied data in place of the original data, can dramatically increase the throughput (the number of application requests serviceable per unit time) and scalability of middle tier applications. http://www.sqlservercentral.com/redirect/articles/619/2002/03/08http://www.sqlservercentral.com/redirect/articles/619/