Adam Machanic, Boston-based SQL Server developer, shares his experiences with programming, monitoring, and performance tuning SQL Server. And the occasional battle with the query optimizer.
Browse by Tags
» SQL Server 2005 (RSS)
Sorry, but there are no more tags available to filter with.
SQL Server 2000 included a very useful extended stored procedure called xp_execresultset . This XP had two parameters: @cmd and @dbname . @cmd was expected to be a SELECT statement that would produce a single column of output, each row of which would Read More...