Answer Posted / Gunjan Sharma
Linked Server is a feature in SQL Server that allows you to access and execute database objects located on other servers as if they were local. It enables data manipulation across heterogeneous data sources, making it possible to perform queries that span multiple databases or even different types of database systems.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is normalization and what are the advantages of it?
Why should you use or avoid select * statements?
How do I start sql server 2017?
How to enter binary string literals in ms sql server?
How can we solve concurrency problems?
How do I find query history in sql server?
Why and when do stored procedure recompile?
Why we use the openxml clause?
Can one drop a column from a table?
What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?
Can we do dml on views?
If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?
When should you use an instead of trigger?
You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?
How to remove duplicate rows from table except one?
