When using linked servers, I believe, all processing occurs on the calling server. For processing to occur on the linked server you would use OpenQuery.
A fundamental skill for DBAs is to have a firm understanding of the SQL Server database engine's system databases. Tim Chapman discusses these system databases. A fundamental skill for DBAs is to have ...
Read and learn about the most common SQL Server services running under your OS (operating system). Tibor writes about five SQL Server database types that each perform a specific role. He also provides ...
DBAs will have to start thinking in terms of groups instead of single servers. SSMS (SQL Server Management Studio) also has much better object-level stats than ever before. This is a perfectly ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results