The Microsoft SQL Server Development Customer Advisory Team has a nice blog post about Distributed Partitioned Views / Federated Databases   They cover the following definitions   Definition 1:  Local Partitioned View – A single table is horizontally split into multiple tables, usually all have the same ...