Interested to Buy Any Domain ? << Click Here >> for more details...
Can you link only other SQL Servers or any database servers
such as Oracle?
- 1 Answers
- 5130 Views
- I also Faced
- E-Mail Answers
Answer / guest
We can link any server provided we have the OLE-DB provider
from Microsoft to allow a link. For Oracle we have a OLE-DB
provider for oracle that microsoft provides to add it as a
linked server to the sql server group.
| Is This Answer Correct ? | 4 Yes | 0 No |
What is factless fact table? : sql server analysis services, ssas
Explain how dts is used to extract, transform and consolidate data?
Where to find ntwdblib.dll version 2000.80.194.0?
What do you mean by an execution plan? How would you view it?
How many clustered indexes can be created on a table? I create a separate index on each column of a table. what are the advantages and disadvantages of this approach?
Why do we partition data?
What are the different types of replication? How are they used?
tell me what are the steps you will take to improve performance of a poor performing query? : Sql server database administration
What do you mean by COLLATION?
What is the name of the system variable that returns the number of rows affected by a SQL statement?
Why use view instead of a table?
What is star, snowflake and star flake schema? : sql server analysis services, ssas
-
Oracle (3253) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
