Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » linked server   (RSS)
Wednesday, September 02, 2009 4:06 PM

Distributed Queries – Remote Login Permissions and Execution Plans

Recently I troubleshooted an issue where a distributed query was randomly getting a poor plan and slow performance where the join would not be remoted.  However, based on the actual data distribution and the join condition, you would expect the join
Posted by psssql | 0 Comments
Wednesday, July 01, 2009 10:12 PM

When in doubt, Reboot!

I tend to get quite a bit of Kerberos related cases.  These are related across the box, from the Engine, to Reporting Services to just straight connectivity with custom applications.  I had one given to me yesterday because the engineer had
Posted by psssql | 0 Comments
Thursday, February 14, 2008 9:35 PM

How It Works: Linked Servers and Collation Compatibility

Customer Question:   "Why I am getting different results when is change collation compatibility from true to false?" This actually turned out to be an interesting issue because no error was raised but the results are different. The query
Posted by psssql | 2 Comments
Wednesday, February 21, 2007 4:55 PM

SQL Server 2005 Service Pack 2 has released! Linked Server GUI is back!

SQL Server 2005 Service Pack 2 (SP2) released on Monday to the web. If you want to start downloading it while reading the rest of the post, go right to http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/servicepacks/sp2.mspx . Over the next
Posted by psssql | 0 Comments
Attachment(s): test_linked_server.bmp
 
Page view tracker