Questions tagged [distributed-queries]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
7
votes
1answer
1k views

Where do Linked Server Queries get executed?

I have two instances ServerA and ServerB, and I have created a linked server in ServerA for ServerB as Linksrv_B. I can execute a query on ServerA using the four part naming convention: SELECT * ...
1
vote
0answers
91 views

What's an example of a Distributed Database Query?

Since I may not come across or get a chance to use a distributed database system. I would like to understand an example of a Distributed Database Query. I know that in a distributed system, you have ...
0
votes
0answers
82 views

Use of remote indexes in distributed queries

I have a MySQL server linked in SQL Server and I can query it like this: select * from [MYSQL]...[table] where [column] = 1 this works, but if the table contains many rows performance drops, even if ...
2
votes
1answer
660 views

how to temporarily change the sql server settings in order to do a task and when finished revert back?

when I run the script below all at once I get this error message: Msg 15281, Level 16, State 1, Line 58 SQL Server blocked access to STATEMENT 'OpenRowset/OpenDatasource' of component 'Ad Hoc ...