Linchi Shea : Linked serverhttp://sqlblog.com/blogs/linchi_shea/archive/tags/Linked+server/default.aspxTags: Linked serverenCommunityServer 2.1 SP2 (Build: 61129.1)Linked servers: set them up in QAhttp://sqlblog.com/blogs/linchi_shea/archive/2011/04/05/linked-servers-set-them-up-in-qa.aspxTue, 05 Apr 2011 18:34:00 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:34681Linchi Shea10http://sqlblog.com/blogs/linchi_shea/comments/34681.aspxhttp://sqlblog.com/blogs/linchi_shea/commentrss.aspx?PostID=34681How do you set up linked servers in your QA environment? You set them up the same as you do in the production environment, right? Why even ask? Correct. There is no difference in the actual steps of setting up a linked server between your QA and prod....(<a href="http://sqlblog.com/blogs/linchi_shea/archive/2011/04/05/linked-servers-set-them-up-in-qa.aspx">read more</a>)<img src="http://sqlblog.com/aggbug.aspx?PostID=34681" width="1" height="1">Best PracticesLinked serverQALinked servers: how long do they stay connected?http://sqlblog.com/blogs/linchi_shea/archive/2011/03/31/linked-servers-how-long-do-they-stay-connected.aspxFri, 01 Apr 2011 00:36:00 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:34537Linchi Shea4http://sqlblog.com/blogs/linchi_shea/comments/34537.aspxhttp://sqlblog.com/blogs/linchi_shea/commentrss.aspx?PostID=34537I was looking at some of my old notes on linked servers and found a tidbit on how the linked server connections are managed by SQL Server. I'm posting it here because I don’t think the information is widely known. When you make a linked server call from...(<a href="http://sqlblog.com/blogs/linchi_shea/archive/2011/03/31/linked-servers-how-long-do-they-stay-connected.aspx">read more</a>)<img src="http://sqlblog.com/aggbug.aspx?PostID=34537" width="1" height="1">Linked serverTestingLinked servers and performance impact: Direction matters!http://sqlblog.com/blogs/linchi_shea/archive/2010/12/01/linked-server-and-performance-impact-direction-matters.aspxWed, 01 Dec 2010 04:31:00 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:31203Linchi Shea9http://sqlblog.com/blogs/linchi_shea/comments/31203.aspxhttp://sqlblog.com/blogs/linchi_shea/commentrss.aspx?PostID=31203When you have some data on a SQL Server instance (say SQL01) and you want to move the data to another SQL Server instance (say SQL02) through openquery(), you can either push the data from SQL01, or pull the data from SQL02. To push the data, you can...(<a href="http://sqlblog.com/blogs/linchi_shea/archive/2010/12/01/linked-server-and-performance-impact-direction-matters.aspx">read more</a>)<img src="http://sqlblog.com/aggbug.aspx?PostID=31203" width="1" height="1">Best PracticesLinked serverPerformanceLinked servers: permissions and distributed query performancehttp://sqlblog.com/blogs/linchi_shea/archive/2010/11/23/linked-servers-permissions-and-distributed-query-performance.aspxTue, 23 Nov 2010 04:58:00 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:30897Linchi Shea8http://sqlblog.com/blogs/linchi_shea/comments/30897.aspxhttp://sqlblog.com/blogs/linchi_shea/commentrss.aspx?PostID=30897In an earlier post , I highlighted that linked server security configuration can have a huge performance impact, and complained that this was not properly documented in SQL Server Books Online and filed a Connectitem for this. Good news is that in Books...(<a href="http://sqlblog.com/blogs/linchi_shea/archive/2010/11/23/linked-servers-permissions-and-distributed-query-performance.aspx">read more</a>)<img src="http://sqlblog.com/aggbug.aspx?PostID=30897" width="1" height="1">Best PracticesDistributed joinDistributed queryLinked serverPerformanceQuery ProcessingLinked servers: a case for global temporary tableshttp://sqlblog.com/blogs/linchi_shea/archive/2010/11/17/linked-servers-a-case-for-global-temporary-tables.aspxWed, 17 Nov 2010 21:28:00 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:30694Linchi Shea20http://sqlblog.com/blogs/linchi_shea/comments/30694.aspxhttp://sqlblog.com/blogs/linchi_shea/commentrss.aspx?PostID=30694I'm not a SQL Server historian, so I don't know exactly when the global temporary table was first introduced into SQL Server. The feature may have been around since the very genesis of SQL Server. But I know for sure that it has been there since I started...(<a href="http://sqlblog.com/blogs/linchi_shea/archive/2010/11/17/linked-servers-a-case-for-global-temporary-tables.aspx">read more</a>)<img src="http://sqlblog.com/aggbug.aspx?PostID=30694" width="1" height="1">global temp tableLinked serverTemp tableLinked servers: Can you do DDLs via openquery()?http://sqlblog.com/blogs/linchi_shea/archive/2010/11/15/linked-servers-can-you-do-ddls-via-openquery.aspxMon, 15 Nov 2010 21:23:00 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:30606Linchi Shea8http://sqlblog.com/blogs/linchi_shea/comments/30606.aspxhttp://sqlblog.com/blogs/linchi_shea/commentrss.aspx?PostID=30606More specifically, can you create a table in openquery() over a linked server on another SQL Server instance using the SQL Server Native Client OLE DB provider? I don’t know what the official story is on this because I can’t seem to find any explicit...(<a href="http://sqlblog.com/blogs/linchi_shea/archive/2010/11/15/linked-servers-can-you-do-ddls-via-openquery.aspx">read more</a>)<img src="http://sqlblog.com/aggbug.aspx?PostID=30606" width="1" height="1">DDLLinked servertransactionsBad database practices: moving data to procedures vs. moving procedures to datahttp://sqlblog.com/blogs/linchi_shea/archive/2009/10/30/database-bad-practices-moving-data-to-the-procedures-vs-moving-procedures-to-data.aspxFri, 30 Oct 2009 04:00:00 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:18365Linchi Shea2http://sqlblog.com/blogs/linchi_shea/comments/18365.aspxhttp://sqlblog.com/blogs/linchi_shea/commentrss.aspx?PostID=18365Is it better to move data to procedures or move procedures to data? The answer is, of course, “it depends.” Let’s consider a scenario where you have two SQL Server instances: ServerA and ServerB, and you have a procedure on ServerB (call it procB), but...(<a href="http://sqlblog.com/blogs/linchi_shea/archive/2009/10/30/database-bad-practices-moving-data-to-the-procedures-vs-moving-procedures-to-data.aspx">read more</a>)<img src="http://sqlblog.com/aggbug.aspx?PostID=18365" width="1" height="1">ArchitectureBad database practicesBest PracticesDistributed queryLinked serverPerformanceFind the complete call tree for a stored procedurehttp://sqlblog.com/blogs/linchi_shea/archive/2009/10/23/find-the-complete-call-tree-for-a-stored-procedure.aspxFri, 23 Oct 2009 03:11:00 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:18173Linchi Shea4http://sqlblog.com/blogs/linchi_shea/comments/18173.aspxhttp://sqlblog.com/blogs/linchi_shea/commentrss.aspx?PostID=18173Would it be nice to print out the complete call tree of a stored procedure? By complete call tree , I mean the following: · At the very top level, the call tree should identify all the procedures that are called directly. · For any given level, the next...(<a href="http://sqlblog.com/blogs/linchi_shea/archive/2009/10/23/find-the-complete-call-tree-for-a-stored-procedure.aspx">read more</a>)<img src="http://sqlblog.com/aggbug.aspx?PostID=18173" width="1" height="1">AutomationLinked serverPerlScriptingScriptsToolsT-SQLPerformance impact: Linked server security configuration and how it can hurt youhttp://sqlblog.com/blogs/linchi_shea/archive/2009/07/21/performance-impact-linked-server-security-configuration-and-how-it-can-hurt-you.aspxTue, 21 Jul 2009 17:16:00 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:15387Linchi Shea22http://sqlblog.com/blogs/linchi_shea/comments/15387.aspxhttp://sqlblog.com/blogs/linchi_shea/commentrss.aspx?PostID=15387If you change the security configuration of a linked server from using login UserA to login UserB, would you expect that to significantly impact the performance of a query that uses the linked server, assuming that both users have permission to select...(<a href="http://sqlblog.com/blogs/linchi_shea/archive/2009/07/21/performance-impact-linked-server-security-configuration-and-how-it-can-hurt-you.aspx">read more</a>)<img src="http://sqlblog.com/aggbug.aspx?PostID=15387" width="1" height="1">Distributed joinDistributed queryLinked serverPerformanceQuery ProcessingSecurity