Recap
You create a server federation by creating a partitioned view that's distributed across a group of servers. These servers refer to one another via regular linked server references.
SQL Server imposes a number of restrictions on partitioned views, but once those restrictions are met, the query optimizer on each server in the federation handles eliminating unnecessary partitions (either at compile-time or at runtime) so that these partitions are not needlessly scanned for matching rows.
Get Guru's Guide to SQL Server Architecture and Internals, The now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
