Question : I have a really big query that needs to be run on multiple databases, and the results appended […]
Tag: linked-server
Can the FORCESEEK query hint be used on tables being queried against on a linked server? (I.e. as part of a distributed query)
Question : I have a query that uses the FORCESEEK hint and runs fine on the server where the database […]
How do I connect to a database which is a linked server via ODBC?
Question : (All the searches for this sort of thing tell me about where the linked server is connecting to […]
OLTP – Stretch database vs linked server
Question : From my understanding, when you enable the StretchDB feature for a table, basically creates a Linked Server locally, […]
“SQLNCLI11” for linked server “linkedserver” returned message “The transaction manager has disabled its support for remote/network transactions.”
Question : I have a database in a SQL Server 2014 AG group (AG1).- two nodes. On both nodes, a […]
Direct vs Linked Server Connection in Query Execution Time
Question : After investigating our ETL Process for months i fell into something strange. We have one machine (A) which […]
Inserting a 30 million row table from a linked server
Question : I have a large table that needs to be updated on a nightly basis from a linked server. […]
Join SQL Server table in OPENQUERY on multiple keys
Question : I need to join an Oracle linked server table (with 1 billion rows) with an SQL Server table […]
Server 2012 Linked Server From An Instance
Question : I have 3 SQL Server 2012 Instances, 2 on SiteA on the same server SiteAServer. I have 1 […]
Linked Server Timeout – Not Queried
Question : I have a job that runs for multiple regions across the globe. Depending on what region is running […]