Linked servers allows to issue SQL commands against OLE DB providers. Because Microsoft also makes available an “OLE DB Provider for ODBC Drivers”, it is also possible to issue queries against a variety of ODBC drivers. With linked servers and distributed queries, you can query all sorts of data sources and merge them on the […]
Posts Tagged ‘distributed query’
October 23, 2011 by Francois · 3 Comments
Filed under: Administration, Performance
Social Tagging: collation • distributed query • linked server • query plan • remote query • sql server • statistics • sub-optimal query plan • TSQL • Use Remote Collation
Filed under: Administration, Performance
Social Tagging: collation • distributed query • linked server • query plan • remote query • sql server • statistics • sub-optimal query plan • TSQL • Use Remote Collation
RSS