Distributed queries access data from multiple heterogeneous data sources. These data sources can be stored on either the same or different computers. Microsoft SQL Server supports distributed queries by using OLE DB.
SQL Server users can use distributed queries to access the following:
#. Distributed data stored in multiple instances of SQL Server.
#. Heterogeneous data stored in various relational and nonrelational data sources accessed by using an OLE DB provider.
For more details visit http://msdn.microsoft.com/en-us/library/ms188721.aspx
Asked In: Many Interviews |