Skip to content
DbaFix
Just share answer and question for fixing database problem
MENU
  • HOME

Tag: linked-server

How can I query data from a linked server, and pass it parameters to filter by?

By adminPosted on February 3, 2023

Question : I have a really big query that needs to be run on multiple databases, and the results appended […]

Can the FORCESEEK query hint be used on tables being queried against on a linked server? (I.e. as part of a distributed query)

By adminPosted on January 26, 2023

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?

By adminPosted on January 22, 2023

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

By adminPosted on January 21, 2023

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.”

By adminPosted on January 18, 2023

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

By adminPosted on January 17, 2023

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

By adminPosted on January 15, 2023

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

By adminPosted on January 9, 2023

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

By adminPosted on January 7, 2023

Question : I have 3 SQL Server 2012 Instances, 2 on SiteA on the same server SiteAServer. I have 1 […]

Linked Server Timeout – Not Queried

By adminPosted on January 2, 2023

Question : I have a job that runs for multiple regions across the globe. Depending on what region is running […]

  • 1
  • 2
  • 3
  • …
  • 31

Recent Posts

  • Update statement errors, parenthesis, failed validation ORACLE
  • postgresql grant user privilages to dynamically created tables
  • How can streaming replication be kept lagged by a certain ‘delay’ time?
  • Query for similar syllables on a field
  • Write filename, servername/IP and date+time in spool file
  • Designing a table with multiple null FKs
  • I am trying to get the string between hyphen (-) which is before (+) upto next colon (:)
  • Why would a SELECT INTO cause an arithmetic overflow?
  • Possibility to implement time to execute / TempDB usage restrictions on some role groups in SQL Server?
  • Login failed for user – Error 18456 – Severity 14, State 38
  • comparing two values in same column with another column using AND condition
  • Slow running aggregate of aggregate query
  • Is it possible to get seek based parallel plan for distinct/group by?
  • PostgreSQL replication: out-of-sequence timeline ID, when former master made slave
  • Autogrowth Analysis in PROD DB based on the trace file data
  • Single versus Multiple databases
  • Does a user who has permissions to select from a view also need select granted to the children entities of that view?
  • Parse a string to find data between delimiters, multiple occurrences
  • Oracle multiple databases on same server [closed]
  • Help to create indexes to improve query performance and reduce report generation time

Categories

  • Database Backup
  • Database Design
  • Database Index
  • Database Optimization
  • InnoDB
  • Join
  • MariaDB
  • MongoDB
  • MySQL
  • Oracle
  • Performance
  • Permissions
  • Postgresql
  • Query Performance
  • Replication
  • Security
  • SQL Server
Proudly powered by WordPress / Support by: DizzyCoding