Yahoo Web Search

Search results

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

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

   www.mssqltips.com › sqlservertip › 6083

   • Cached

   Apr 7, 2022 · Solution. 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.

   • 
   • 
   • 
   • 

3. Videos

   • 

     sqlshack.com

     Querying remote data sources in SQL Server

     31 Dec 2008

     168 views

   • 

     1:16

     youtube.com

     The science behind how a remote control works

     31 Oct 2016

     189.1K views

   • 

     2:10

     youtube.com

     Why Work Remotely?

     15 Apr 2020

     42.7K views

   View all

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

   techcommunity.microsoft.com › t5 › azure-database

   • Cached

   Oct 21, 2020 · Remote Join: when you have an inner join between local and remote table (a linked server) , you can force the join operation to be on the remote server. If you have two tables , one local small table (10 rows in my example testdest table) and one huge linked server table ( sourctbl table with about 76 million rows)

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

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

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