What is a Linked Server in SQL Server and when is it used?
A Linked Server allows SQL Server to execute commands against different databases, especially on separate servers over the network. It is used when you need to access data from another SQL Server instance.