November 2009 - Posts

• Bad database practices: abusing linked servers

  In SQL Server, it is rather handy to retrieve data from a different SQL Server instance and use the result locally in another SQL statement for further processing. In theory and in the set purists’ fantasy land, it shouldn’t matter where you get your Read More... Posted Friday, November 06, 2009 8:56 PM by Linchi Shea | 6 Comments Filed under: Performance, Best Practices, Query Processing, Distributed join, Bad database practices

• I didn't know you could do this!

  create proc p_test as -- multiple resultsets select @@servername as ServerName; select 'abc'; select srvname from sysservers; go create table #tmp ( ServerName sysname ) go INSERT #tmp EXECUTE p_test; I did not know that the last statement above (i.e. Read More... Posted Friday, November 06, 2009 12:50 PM by Linchi Shea | 6 Comments Filed under: Random thoughts