Say you have two identical SQL Servers with similar databases in two different branches. Only the database sizes differ by about 20% and server machine are also identical. You will get a complaint that the performance of one is very very low compare to another, so how to find the issue to resolve? If...
Source: Knowledge Base Product: Microsoft SQL Server 2005 Standard Edition, SQL Server 2005 Enterprise X64 Edition & SQL Server 2005 Enterprise Edition Notification Contents: New and All Modifications FIX: Error messages when you run a query against a linked server that you create in SQL Server 2005...