Yahoo Web Search

Search results

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

2. stackoverflow.com › questions › 2347100t sql - quering remote database using sql server? - Stack ...

   stackoverflow.com › questions › 2347100

   Sep 27, 2016 · DECLARE @RemoteSP varchar(500) SET @RemoteSP = '[server\instance].database2.schema.proc2' EXEC @RemoteSP @p1, @p2, @p3 OUTPUT. SET @RemoteSP = '[server\instance].database1.schema.proc1'

3. www.sqlshack.com › how-to-connect-to-a-remote-sqlHow to connect to a remote SQL Server - SQL Shack

   www.sqlshack.com › how-to-connect-to-a-remote-sql

   • Cached

   Feb 18, 2016 · Remote access is the ability to get access to a SQL Server from a remote distance in order to manipulate data which are located on that SQL Server. There are two types of adjustments which must be set before connecting to the remote SQL Server.

4. learn.microsoft.com › en-us › sqlConnect and query SQL Server using SSMS - SQL Server ...

   learn.microsoft.com › en-us › sql

   • Cached

   Feb 29, 2024 · This article covers connecting and querying an instance of SQL Server. For Azure SQL, see Connect and query Azure SQL Database & SQL Managed Instance. To use Azure Data Studio, see connect and query SQL Server, Azure SQL Database, and Azure Synapse Analytics.

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

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

   • Cached

   Sep 30, 2020 · Getting started. Because a data source is remote, we may or may not have any control over the data and schema stored there. Part of the data discovery process is to understand the remote data source and its contents. Some questions worth asking before diving in are: Do I control this data source, or is it owned and maintained by others?

6. www.mssqltips.com › sqlservertip › 7192How to Connect to a SQL Database - SQL Server Tips

   www.mssqltips.com › sqlservertip › 7192

   • Cached

   Mar 23, 2022 · Learn how to make a connection to a SQL Server database and how to connect to a database using SQL Server Management Studio and Azure Data Studio.

7. People also ask

   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

   Is a database on the same SQL server remote?

   • Databases on the same SQL Server that can be referenced without a linked server or remote alias are not considered remote, whereas the following are examples of remote data sources: SQL Servers configured on other instances in the same cluster or on the same server. SQL Servers on remote hardware/platforms.

   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 system efficiently?

   • 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. Doing so requires an efficient remote query AND a local query that receives and processes that data 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

   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

8. techcommunity.microsoft.com › t5 › sql-serverConnecting to SQL Server Using PowerShell - Microsoft ...

   techcommunity.microsoft.com › t5 › sql-server

   • Cached

   Jan 15, 2019 · Let us consider a situation where you are in a remote machine and you don’t have SQL Server Management Studio (SSMS) client tool to access the SQL Server and you would like to query your SQL Server. In this case, PowerShell command is one of the best way to query the data. Using a SQL Server Provider Path : SQL Server: HEARTTHROB.