Last time I showed how to create a connection to an Oracle database by creating a Linked Server in SQL Server. Most of the time this works fine, but when you are pulling a lot of information, it tends to run slow. By using OPENQUERY, the query will run very, very fast.
Sometimes you need to pull data from an Oracle database into your SQL Server database. No magic is required, you just need to use a Linked Server. This article will show you how easy it is.