分布式查询

• Sql server users can use distributed queries to access the following
  Sql server用户可以使用分布式查询访问以下内容：
• Set ansi nulls should be set to on for executing distributed queries
  在执行分布式查询时应将set ansi _ nulls设置为on 。
• Ad hoc distributed queries
  即席分布式查询
• For information about new and enhanced functionality for distributed queries , see
  有关分布式查询的新增和增强型功能的信息，请参阅
• Sql server provides several advanced options for managing distributed queries
  Sql server提供了若干用于管理分布式查询的高级选项。
• Executes a distributed query that accesses a table stored in linked server
  中存储的表的分布式查询时，则当sql server连接到链接服务器
• The name of the range can then be referenced as a table name in a distributed query
  这样，可以在分布式查询中将此范围的名称引用为表名称。
• So most research of distributed query optimization aim at reducing communication cost
  所以大多数研究分布式查询优化以减少通讯开销为目标。
• Not specifying a schema name in a distributed query prevents ole db from finding tables
  没有在分布式查询中指定架构名称将禁止ole db查找表。
• Therefore , using except and intersect in distributed queries may affect performance
  因此，在分布式查询中使用except和intersect可能会影响性能。