I have a set of queries that query a linked server using 4 part naming.  Some of these use temp tables and some do not.  We started seeing slow performance...

If you're using Excel 2007 or later the workbooks are a collection of xml files under the hood. "In theory" you could import those xml files into a SQL...