Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag Distributed Queries Rss

   Items 1 to 17 of 17   
 

How to join a local table to a remote table by way of a linked server

Distributed queries on linked servers are not the greatest idea from a performance standpoint, but they can be quite useful.  Read more...
By Stan Kulp 2012/02/27 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 10,504 reads

Updating AS/400 Linked Server Tables from SQL Server

One of the strongest features of SQL Server is the ability to connect to disparate data sources and perform queries across multiple sources. New author Basu Hullur brings us a technique that he used to update data on the AS/400 in a much quicker way than previously.   Read more...
By Basu Hullur 2007/07/06 (first published: 2006/04/05) | Source: SQLServerCentral.com | Category: distributed queries
Rating: |  Discuss |   Briefcase | 42,478 reads

An Introduction To Linked Servers

Linked Servers are an interesting technology in SQL Server to allow remote access from within the database to external data sources. They can be a boon in a heterogenous environment with other Oracle, DB2, etc. data sources. But they can also help in a smaller scale against those "hidden" datasources like Excel or Access. New Author Krishna.   Read more...
By Krishna Sonti 2007/06/08 (first published: 2004/06/02) | Source: SQLServerCentral.com | Category: distributed queries
Rating: |  Discuss |   Briefcase | 47,046 reads

Updating AS/400 Linked Server Tables from SQL Server

One of the strongest features of SQL Server is the ability to connect to disparate data sources and perform queries across multiple sources. New author Basu Hullur brings us a technique that he used to update data on the AS/400 in a much quicker way than previously.   Read more...
By Basu Hullur 2007/07/06 (first published: 2006/04/05) | Source: SQLServerCentral.com | Category: distributed queries
Rating: |  Discuss |   Briefcase | 42,478 reads

Oracle and SQL Server Interoperability Part 3

Haindong Ji brings us part 3 of his series on Oracle and SQL Server interoperability, this time taking a look at the Oracle Instant Client.   Read more...
By Haidong Ji 2006/01/24 | Source: SQLServerCentral.com | Category: distributed queries
Rating: |  Discuss |   Briefcase | 11,785 reads

Connect to Lotus Domino using SQL Server Linked Server

Many Enterprises create and maintain applications that reside on "IBM Lotus Domino Server." Since the Lotus Domino server has the capability of handling applications and messaging, it has become a prime requirement for a SQL Server DBA to cross- reference data or import and export data to and from the Domino database and SQL Server databases. In this article, I am going to discuss how to use SQL Server Linked server to connect to databases that reside on the Lotus Domino server. The steps involved in connecting to the Lotus notes mail server database can be used for connecting to other databases that reside in "Lotus Notes Domino" server.   Read more...
By Additional Articles 2005/01/31 | Source: Database Journal | Category: distributed queries
Rating:  Rate this |   Briefcase | 2,067 reads

Linked Servers: Creating, Setting Options, and Querying

Have you ever had to access data from either a non-SQL Server source or from a separate SQL Server database (either residing on the same instance or on a separate instance)? Rahul Sharmas discusses how to bridge the gap between two different SQL Server instances or between heterogenous RDBMS such as SQL Server and Oracle: Use linked servers!  Read more...
By Additional Articles 2005/01/17 | Source: Other | Category: distributed queries
Rating:  Rate this |   Briefcase | 2,938 reads

Oracle Link

SQL Server is the best RDBMS, at least according to the current thinking at SQLServerCentral.com, and is fully capable of meeting all of your database needs. However not all database systems run on SQL Server and it seems that we often see data from some other system being consolidated on SQL Server for additional processing or reporting. DTS usually handles the load, but there are times that you might want create a linked server to an Oracle system for updating individual rows. New author Adria   Read more...
By Adrian Small 2004/12/29 | Source: SQLServerCentral.com | Category: distributed queries
Rating: |  Discuss |   Briefcase | 17,263 reads

An Introduction To Linked Servers

Linked Servers are an interesting technology in SQL Server to allow remote access from within the database to external data sources. They can be a boon in a heterogenous environment with other Oracle, DB2, etc. data sources. But they can also help in a smaller scale against those "hidden" datasources like Excel or Access. New Author Krishna.   Read more...
By Krishna Sonti 2007/06/08 (first published: 2004/06/02) | Source: SQLServerCentral.com | Category: distributed queries
Rating: |  Discuss |   Briefcase | 47,046 reads

Review of SQL 2000 Fast Answers

A monster book at 980 pages, it's written in 'how-to' format and has a ton of good material. Andy gave it the once over for us and reports back - see what he thinks!   Read more...
By Andy Warren 2003/04/18 | Source: SQLServerCentral.com | Category: installation
Rating: |  Discuss |   Briefcase | 18,205 reads

Adding Linked Servers Using SQL-DMO

Following up on a question posted in our discussion area, Andy looks at how to use DMO to add and remove linked servers. Along the way he points out a couple 'gotchas' and throws in a cool tip about how to save a little time when you experiment with DMO.   Read more...
By Andy Warren 2002/09/19 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 12,117 reads

Middle Tier Application Data Caching with SQL Server 2000

Middle tier applications often use a single database management system (DBMS) to store data, which can expose scaling limitations as the number of user requests increases. Caching, a technique used to increase application performance by copying data and then using the copied data in place of the original data, can dramatically increase the throughput (the number of application requests serviceable per unit time) and scalability of middle tier applications.   Read more...
By Additional Articles 2002/03/08 | Source: Microsoft SQL Home | Category: administration
Rating:  Rate this |   Briefcase | 1,728 reads

SQL Server 7.0 and OLE DB Heterogeneous Queries

This article discusses queries that involve more than one database server. For example, you can run a query that returns a joined recordset where some records come from a SQL Serverâ„¢ database and others come from an AS/400 machine.   Read more...
By Additional Articles 2001/06/06 | Source: Microsoft MSDN | Category: distributed queries
Rating:  Rate this |   Briefcase | 1,166 reads

Conversion of DB2 Data to SQL Server through DTS

In this article, Brian Knight shows you how to convert data stored in DB2 to SQL Server using DTS.   Read more...
By Brian Knight 2001/05/09 | Source: SQLServerCentral.com | Category: dts
Rating: |  Discuss |   Briefcase | 6,950 reads

StarSQL 3.0 Configuration

In this article, you are shown how to configure StarSQL, which is one method to rapidly connect to DB2 databases.   Read more...
By Brian Knight 2001/05/07 | Source: SQLServerCentral.com | Category: distributed queries
Rating: |  Discuss |   Briefcase | 3,351 reads

Viewing Linked Servers' Meta Data

So, you've added a linked server and need information about it. There must be an easier way to fine information about your linked server and keep from walking to the server room.   Read more...
By Brian Knight 2001/05/07 | Source: SQLServerCentral.com | Category: distributed queries
Rating: |  Discuss |   Briefcase | 7,630 reads

Uncovering Linked Servers

A little known feature that SQL Server offers is linked servers. Linked servers give the developer the option to use distributed queries and are a vital part of SQL Server's scalability.   Read more...
By Brian Knight 2001/05/06 | Source: SQLServerCentral.com | Category: distributed queries
Rating: |  Discuss |   Briefcase | 21,056 reads
   Items 1 to 17 of 17   
 
Tags
sql server 7 (14)    
administration (3)    
configuring (3)    
dts (2)    
miscellaneous (2)    
performance tuning (2)    
replication (2)    
t-sql (2)    
backup / restore (1)    
english query (1)    
indexing (1)    
installation (1)    
linked servers (1)    
monitoring (1)    
openxml (1)    
programming (1)    
security (1)    
sql-dmo (1)    
stored procedures (1)    
triggers (1)    
updategrams (1)    
user defined function (udf) (1)    
visual basic 6 (1)    
xml (1)    
xsl (1)