In our recent findings, we have found that the Update statement with LinkedServer could cause database performance issue, which end up giving you a "server is not responding" or timeout error message.
The solution to resolve this issue, is to change the Update LinkedServer.Table statement to Update OpenQuery statement.
This solution is tested and proven workable.
Subscribe to:
Posts (Atom)
-
Finally Windows 7 shows its face, but only Beta version now. The latest version of Microsoft's Windows operating system became popular s...
-
Environment: Visual Studio Code v1.83.1 Symtomps: 1). When you try to debug your Flutter project, you see this error message at the Terminal...
-
The easiest way to do it using the keytool command. Example: keytool -printcert -jarfile <apk_file>
