Yahoo Web Search

Search results

1. www.mssqltips.com › sqlservertip › 6083Understanding SQL Server Linked Servers

   www.mssqltips.com › sqlservertip › 6083

   • Cached

   Apr 7, 2022 · Linked Servers are a method by which a SQL Server can talk to another ODBC compliant database, such as another SQL Server instance or an Oracle database, with a direct T-SQL query. There are several important settings to know when setting up a Linked Server.

2. learn.microsoft.com › en-us › sqlQuery remote servers (Database Engine) - SQL Server ...

   learn.microsoft.com › en-us › sql

   • Cached

   Mar 23, 2023 · In SQL Server, there are three ways to execute a query remotely: OPENQUERY. OPENROWSET. EXECUTE AT. This article describes these three methods. OPENQUERY (Transact-SQL) Executes the specified pass-through query on the specified linked server. This server is an OLE DB data source. In a query, use OPENQUERY in the FROM as if it were a table name.

3. www.sqlshack.com › querying-remote-data-sources-inQuerying remote data sources in SQL Server - SQL Shack

   www.sqlshack.com › querying-remote-data-sources-in

   • Cached

   Jun 10, 2016 · SQL Server provides us with four useful methods to connect to the remote database servers, even other database server types, and query its data within your T-SQL statement. In this article, we will discuss these four methods and how to use it to query remote SQL Server databases.

4. Videos

   • 

     1:10:56

     youtube.com

     Lecture 1 Basic Concepts of Remote Sensing

     12 Oct 2020

     58.9K views

   • 

     40:50

     youtube.com

     Geographic Information Systems (GIS) concepts simplified

     4 Jun 2020

     182K views

   • 

     sqlshack.com

     Querying remote data sources in SQL Server

     31 Dec 2008

     168 views

   View all

5. sqlsolutionsgroup.com › using-linked-servers-theUsing Linked Servers the Right Way | SQL Solutions Group

   sqlsolutionsgroup.com › using-linked-servers-the

   • Cached

   Oct 28, 2012 · Linked Servers are a very popular way to access distributed data in environments with lots of SQL Server instances on different serves, or even on other Database Management Systems like Oracle or MySQL.

   • Author: Randy Knight

6. techcommunity.microsoft.com › t5 › azure-databaseTechniques to enhance Linked Server performance - Microsoft ...

   techcommunity.microsoft.com › t5 › azure-database

   • Cached

   Oct 21, 2020 · * it is a important to create a covering index on remote server as well, rowID in our example here. * Remote hint is working only for Inner Join not outer joins.

7. www.red-gate.com › simple-talk › databasesEfficiently polling remote data sources - Simple Talk

   www.red-gate.com › simple-talk › databases

   • Cached

   Sep 30, 2020 · The key to efficient remote querying is to ensure that as much grouping, filtering, joining, and data simplification as possible occurs remotely. The more data that is dragged back to SQL Server, the more computing resources will be needed to move and crunch the extra data and the longer a query will take to complete.

8. People also ask

   What is remote querying and why is it important?

   • The key to efficient remote querying is to ensure that as much grouping, filtering, joining, and data simplification as possible occurs remotely. The more data that is dragged back to SQL Server, the more computing resources will be needed to move and crunch the extra data and the longer a query will take to complete.

   Efficiently polling remote data sources - Simple Talk

   www.red-gate.com/simple-talk/databases/sql-server/performance-sql-server/efficiently-polling-remote-data-sources/

   See all results for this question

   How to query a remote server efficiently?

   • Once complete, the remote server can drop the results into a table. When the data is needed, SQL Server can pull data from the results table, rather than issuing an expensive query on-the-fly to the remote server. In general, there are no shortcuts to querying remote systems efficiently.

   Efficiently polling remote data sources - Simple Talk

   www.red-gate.com/simple-talk/databases/sql-server/performance-sql-server/efficiently-polling-remote-data-sources/

   See all results for this question

   How to execute a query remotely in SQL Server?

   • In SQL Server, there are three ways to execute a query remotely: This article describes these three methods. OPENQUERY (Transact-SQL) Executes the specified pass-through query on the specified linked server. This server is an OLE DB data source. In a query, use OPENQUERY in the FROM as if it were a table name.

   Query remote servers (Database Engine) - SQL Server | Microsoft Learn

   learn.microsoft.com/en-us/sql/relational-databases/linked-servers/linked-servers-openquery-openrowset-exec-at?view=sql-server-ver16

   See all results for this question

   What happens if a SQL query is sent to a remote server?

   • In the OpenQuery function case, the SQL Engine will not try to classify the query or check what it will do, simply it will send the query as is to the remote server. Parsing the SQL query, generating the execution plan and all filtering will be performed on the remote server.

   Querying remote data sources in SQL Server - SQL Shack

   www.sqlshack.com/querying-remote-data-sources-in-sql-server/

   See all results for this question

9. dba.stackexchange.com › questions › 10873SQL Server Linked Server performance: Why are remote queries ...

   dba.stackexchange.com › questions › 10873

   The server calling the remote linked server needs to first establish a connection, then a query needs to be executed on the remote server, results returned and the connection closed. This all takes time over the network.